SELECT * FROM `data_bank` LIMIT 1,3;
改写为:
SELECT * FROM `data_bank` WHERE id >=(SELECT id FROM `data_bank` LIMIT 1,1) LIMIT 3;
或
SELECT * FROM `data_bank` a JOIN(SELECT id FROM `data_bank` LIMIT 1,3) b ON a.ID=b.id;SELECT * FROM `data_bank` LIMIT 1,3;
改写为:
SELECT * FROM `data_bank` WHERE id >=(SELECT id FROM `data_bank` LIMIT 1,1) LIMIT 3;
或
SELECT * FROM `data_bank` a JOIN(SELECT id FROM `data_bank` LIMIT 1,3) b ON a.ID=b.id;