[MySQL] MySQL索引优化之分页探索详细介绍

• ​​mysql​​索引优化之分页探索
  
  
  
  • 案例一
    
  • 案例二
    
  
  

create table `demo` (
  `id` int(11) not null auto_increment,
  `name` varchar(50) character set utf8mb4 collate utf8mb4_0900_ai_ci not null default '' comment '姓名',
  `age` int(11) not null default '0' comment '年龄',
  `position` varchar(50) character set utf8mb4 collate utf8mb4_0900_ai_ci not null default '' comment '职位',
  `card_num` varchar(255) character set utf8 collate utf8_general_ci default null comment '工卡号',
  primary key (`id`),
  key `index_union` (`name`,`age`,`position`)
) engine=innodb auto_increment=450003 default charset=utf8;
 
450003条数据