Update a worker in the Chapter 5 sample database


Select a Worker to update:



SELECT * from Worker WHERE empId=''

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




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



Back to the home page