MySQL索引八大法则之上篇
作者:应用开发 来源:IT科技 浏览: 【大中小】 发布时间:2025-11-05 08:52:15 评论数:
复制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.