1、创建数据库表,以员工信息表为例子:
DROP TABLE IF EXISTS `em_info`;
CREATE TABLE `em_info` (
`em_id` INT(50) NOT NULL AUTO_INCREMENT COMMENT '员工ID',
`em_name` VARCHAR(100) NOT NULL COMMENT '员工姓名',
`em_sex` VARCHAR(30) NOT NULL COMMENT '性别',
`em_birthday` DATE NOT NULL COMMENT '出生日期',
`em_hiredate` DATE NOT NULL COMMENT '入职日期',
`em_salary` DOUBLE NOT NULL COMMENT '工资',
PRIMARY KEY (`em_id`)
)ENGINE=INNODB DEFAULT CHARSET=utf8mb4;
INSERT INTO `em_info` VALUES (NULL,'小李飞刀','男','1999-2-8','2019-6-6','9999');
DROP TABLE IF EXI