SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE Worker ( WORKER_ID INT NOT NULL PRIMARY KEY AUTO_INCREMENT, FIRST_NAME CHAR(25), LAST_NAME CHAR(25), SALARY INT(15), JOINING_DATE DATETIME, DEPARTMENT CHAR(25) ); INSERT INTO Worker (WORKER_ID, FIRST_NAME, LAST_NAME, SALARY, JOINING_DATE, DEPARTMENT) VALUES (001, 'Monika', 'Arora', 100000, '21-02-20 09.00.00', 'HR'), (002, 'Niharika', 'Verma', 80000, '21-06-11 09.00.00', 'Admin'), (003, 'Vishal', 'Singhal', 300000, '21-02-20 09.00.00', 'HR'), (004, 'Amitabh', 'Singh', 500000, '21-02-20 09.00.00', 'Admin'), (005, 'Vivek', 'Bhati', 500000, '21-06-11 09.00.00', 'Admin'), (006, 'Vipul', 'Diwan', 200000, '21-06-11 09.00.00', 'Account'), (007, 'Satish', 'Kumar', 75000, '21-01-20 09.00.00', 'Account'), (008, 'Geetika', 'Chauhan', 90000, '21-04-11 09.00.00', 'Admin'); select * from Worker;