update a worker in the chapter 5 sample database
back
select a worker to update:
----
Tom Smith
Mary Jones
Jane Burns
Michael Burns
Amanda Chin
George Washington
john adams
james madison
worker id:
first name:
last name:
department:
birthday:
hire date:
salary:
display the new worker table
the sql for the update
UPDATE Worker set lastName = '' , firstName = '' , deptName = '' , birthDate = '' , hireDate = '' , salary = '' where empId = ''