 复制DROP TABLE IF EXISTS `tb_emp`; CREATE TABLE `tb_emp` ( `id` int(11) NOT NULL AUTO_INCREMENT,法则 `name` varchar(20) NOT NULL, `age` int(11) NOT NULL, gender varchar(10) NOT NULL, email varchar(20), PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; INSERT INTO `tb_emp` (name,age,gender,email) VALUES (Tom, 22,male,1@qq.com); INSERT INTO `tb_emp` (name,age,gender,email) VALUES (Mary, 21,female,2@qq.com); INSERT INTO `tb_emp` (name,age,gender,email) VALUES (Jack, 27,male,3@qq.com); INSERT INTO `tb_emp` (name,age,gender,email) VALUES (Rose, 23,female,4@qq.com); 1.2.3.4.5.6.7.8.9.10.11.12.13. |