add a worker to the chapter 5 sample database
back
the sql for the insert
INSERT into Worker values
('', '', '', '', '', '', '')
| emp id |
last name |
last name |
dept name |
birth date |
hire date |
salary |
| 101 | Smith | Tom | Accounting | 1970-02-20 | 1993-06-06 | 99500.00 |
| 103 | Jones | Mary | Accounting | 1975-06-15 | 2005-09-20 | 105072.00 |
| 105 | Burns | Jane | Accounting | 1980-09-21 | 1990-12-06 | 77610.00 |
| 110 | Burns | Michael | Research | 1977-05-04 | 2010-09-10 | 139300.00 |
| 115 | Chin | Amanda | Research | 1980-09-22 | 2014-06-19 | 119400.00 |
| 116 | Washington | George | Accounting | 1735-02-24 | 2023-02-02 | 119400.00 |
| 118 | adams | john | Research | 2023-03-16 | 2023-03-17 | 79600.00 |
| 120 | madison | james | Accounting | 2023-03-18 | 2023-03-23 | 39800.00 |