Add a worker to the Chapter 5 sample database.
The sql for the insert
INSERT INTO Worker VALUES ('', '',
'','', '', '',
'')
Emp Id |
First Name |
Last Name |
Dept Name |
Birth Date |
Hire Date |
Salary |
101 | Smith | Tom | Accounting | 1970-02-20 | 1993-06-06 | 54862.50 |
102 | Monroe | James | Research | 2023-03-17 | 2023-03-31 | 69825.00 |
103 | Jones | Mary | Accounting | 1975-06-15 | 2005-09-20 | 57934.80 |
105 | Burns | Jane | Accounting | 1980-09-21 | 1990-12-06 | 38902.50 |
110 | Burns | Michael | Research | 1977-05-04 | 2010-09-10 | 69825.00 |
115 | Chin | Amanda | Research | 1980-09-22 | 2014-06-19 | 59850.00 |
116 | Washington | George | Research | 1960-02-01 | 2023-02-01 | 49875.00 |
888 | Adams | John | Research | 2023-03-30 | 2023-03-31 | 77805.00 |
Return to home page.