Update a worker in the Chapter 5 sample database
Select a Worker to update:
----------
Tom Smith
James Monroe
Mary Jones
Jane Burns
Michael Burns
Amanda Chin
d t
SELECT * FROM Worker WHERE empId = ''
Worker ID:
First Name:
Last Name:
Department Name:
Birthday:
Hire Date:
Salary
The sql for the update
UPDATE Worker SET lastName = '', firstName = '', deptName = '', birthDate = '', hireDate = '', salary = '' WHERE empId = '';