mysql 分页优化

分页优化

 

select * from employees e inner join (select id from employees order by name limit 90000,5) ed
on e.id = ed.id;
 
90001
90002
.....
posted @ 2023-12-14 12:59  lov_ui  阅读(1)  评论(0)  编辑  收藏  举报