Update a worker in the Chapter 5 sample database

Back to the home page

Select a Worker to update:



SELECT * from Worker WHERE empId=''

Worker ID:
First Name:
Last Name:
Department Name:
Birthday:
Hire Date:
Salary:




The sql for the insert
UPDATE Worker SET lastName = '', firstName = '', deptName = '', birthDate = '', hireDate = '', salary = '' WHERE empId='';