· 4 years ago · Dec 09, 2020, 02:00 PM
1CREATE TABLE IF NOT EXISTS `employees` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `type` varchar(100) NOT NULL,
4 `price` decimal(10,10) NOT NULL,
5 `quantity` int(100) NOT NULL,
6 `exp_date` datetime DEFAULT NULL,
7 PRIMARY KEY (`id`)
8) ENGINE=InnoDB DEFAULT CHARSET=utf8;