分页方式二: 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) ;
posted on 2016-09-08 11:13 教父归来 阅读(199) 评论(0) 收藏 举报