Select * from table limit 10000,10；
Limit 10000,10 偏移量越大则越慢
Select * from table WHERE id>=23423 limit 11; #10+1 (每页10条) Select * from table WHERE id>=23434 limit 11;
Select * from table WHERE id >= ( select id from table limit 10000,1 ) limit 10;
Select * from table INNER JOIN (SELECT id from table limit 10000,10) USING(id)
程序取ID: Select id from table limit 10000,10; Select * from table WHERE ID in(123,456…);
原文：https://www.cnblogs.com/waterystone/p/9392421.html