优化Mysql分页

2019独角兽企业重金招聘Python工程师标准>>>

select * from table
where id >= ( select id from table order by id asc limit 900001,1)
limit 20;

转载于:https://my.oschina.net/longjianghu/blog/178991