· 6 years ago · Sep 25, 2019, 03:02 PM
1CREATE TABLE IF NOT EXISTS `Total Salary` (
2 `employee_id` VARCHAR(15) NOT NULL ,
3 `gross_salary` INT NOT NULL ,
4 `wage_cut` INT ,
5 `bonus` INT ,
6 `total_salary` INT NOT NULL,
7 PRIMARY KEY (`employee_id`) )
8ENGINE = InnoDB;