【MySQL系列3】MySQL执行计划EXPLAIN详细说明和举例，看完这篇

最新推荐文章于 2024-05-25 12:00:34 发布

前端node资料大全

最新推荐文章于 2024-05-25 12:00:34 发布

阅读量579

点赞数 21

分类专栏： 2024年程序员文章标签： mysql android 数据库

本文链接：https://blog.csdn.net/m0_60144796/article/details/136868697

版权

insert into test (id, name, company, age, create_time) values(‘57’,‘李四9’,‘baidu11’,‘26’,‘2020-05-29 12:36:28’);

insert into test (id, name, company, age, create_time) values(‘58’,‘李五9’,‘baidu11’,‘27’,‘2020-05-29 12:36:30’);

insert into test (id, name, company, age, create_time) values(‘59’,‘李六9’,‘alibaba11’,‘28’,‘2020-05-29 12:36:31’);

insert into test (id, name, company, age, create_time) values(‘60’,‘张一9’,‘huawei11’,‘18’,‘2020-05-29 12:36:11’);

insert into test (id, name, company, age, create_time) values(‘61’,‘张二9’,‘huawei11’,‘19’,‘2020-05-29 12:36:13’);

insert into test (id, name, company, age, create_time) values(‘62’,‘张三9’,‘huawei11’,‘20’,‘2020-05-29 12:36:15’);

insert into test (id, name, company, age, create_time) values(‘63’,‘张四9’,‘huawei11’,‘22’,‘2020-05-29 12:36:16’);

insert into test (id, name, company, age, create_time) values(‘64’,‘李一9’,‘baidu11’,‘22’,‘2020-05-29 12:36:18’);

insert into test (id, name, company, age, create_time) values(‘65’,‘李二9’,‘huawei11’,‘22’,‘2020-05-29 12:36:24’);

insert into test (id, name, company, age, create_time) values(‘66’,‘李三9’,‘baidu11’,‘22’,‘2020-05-29 12:36:25’);

insert into test (id, name, company, age, create_time) values(‘67’,‘李四9’,‘baidu11’,‘26’,‘2020-05-29 12:36:28’);

insert into test (id, name, company, age, create_time) values(‘68’,‘李五9’,‘baidu11’,‘27’,‘2020-05-29 12:36:30’);

insert into test (id, name, company, age, create_time) values(‘69’,‘李六9’,‘alibaba11’,‘28’,‘2020-05-29 12:36:31’);

insert into test (id, name, company, age, create_time) values(‘70’,‘张一9’,‘huawei11’,‘18’,‘2020-05-29 12:36:11’);

insert into test (id, name, company, age, create_time) values(‘71’,‘张二9’,‘huawei11’,‘19’,‘2020-05-29 12:36:13’);

insert into test (id, name, company, age, create_time) values(‘72’,‘张三9’,‘huawei11’,‘20’,‘2020-05-29 12:36:15’);

insert into test (id, name, company, age, create_time) values(‘73’,‘张四9’,‘huawei11’,‘22’,‘2020-05-29 12:36:16’);

insert into test (id, name, company, age, create_time) values(‘74’,‘李一9’,‘baidu11’,‘22’,‘2020-05-29 12:36:18’);

insert into test (id, name, company, age, create_time) values(‘75’,‘李二9’,‘huawei11’,‘22’,‘2020-05-29 12:36:24’);

insert into test (id, name, company, age, create_time) values(‘76’,‘李三9’,‘baidu11’,‘22’,‘2020-05-29 12:36:25’);

insert into test (id, name, company, age, create_time) values(‘77’,‘李四9’,‘baidu11’,‘26’,‘2020-05-29 12:36:28’);

insert into test (id, name, company, age, create_time) values(‘78’,‘李五9’,‘baidu11’,‘27’,‘2020-05-29 12:36:30’);

insert into test (id, name, company, age, create_time) values(‘79’,‘李六9’,‘alibaba11’,‘28’,‘2020-05-29 12:36:31’);

insert into test (id, name, company, age, create_time) values(‘80’,‘张一科’,‘huawei11’,‘18’,‘2020-05-29 12:36:11’);

insert into test (id, name, company, age, create_time) values(‘81’,‘张二科’,‘huawei11’,‘19’,‘2020-05-29 12:36:13’);

insert into test (id, name, company, age, create_time) values(‘82’,‘张三科’,‘huawei11’,‘20’,‘2020-05-29 12:36:15’);

insert into test (id, name, company, age, create_time) values(‘83’,‘张四科’,‘huawei11’,

关注