1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| DROP TABLE if EXISTS Employees; CREATE TABLE If NOT EXISTS Employees (employee_id INT, name VARCHAR(30), salary INT); TRUNCATE TABLE Employees; INSERT INTO Employees (employee_id, name, salary) VALUES ('2', 'Meir', '3000'); INSERT INTO Employees (employee_id, name, salary) VALUES ('3', 'Michael', '3800'); INSERT INTO Employees (employee_id, name, salary) VALUES ('7', 'Addilyn', '7400'); INSERT INTO Employees (employee_id, name, salary) VALUES ('8', 'Juan', '6100'); INSERT INTO Employees (employee_id, name, salary) VALUES ('9', 'Kannon', '7700');
|