· 6 years ago · Mar 25, 2019, 11:28 AM
1DROP TABLE IF EXISTS `workers`;
2CREATE TABLE `workers` (
3 `id` int(11) NOT NULL AUTO_INCREMENT,
4 `name` varchar(20) NOT NULL,
5 `sex` enum('F','M','S'),
6 `salary` int(11) DEFAULT '0',
7 `email` varchar(30),
8 `EmployedDates` date,
9 `department` varchar(30),
10 PRIMARY KEY (`id`)
11) ENGINE=MyISAM DEFAULT CHARSET=utf8;