SELECt * FROM table1 t,(SELECt id FROM table1 ORDER BY id LIMIT 2000000,10) t2 WHERe t.id = t2.id该方案适用于自增主键，可以把limit查询转换成某个位置的查询
SELECt * FROM table1 WHERe id > 2000000 LIMIT 10;
SELECt * FROM table1 t,(SELECt id FROM table1 ORDER BY id LIMIT 2000000,10) t2 WHERe t.id = t2.id该方案适用于自增主键，可以把limit查询转换成某个位置的查询
SELECt * FROM table1 WHERe id > 2000000 LIMIT 10;
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
