經(jīng)實驗
mysql> select id from table limit 10000000,3 ;
+----------+
| id |
+----------+
| 10039433 |
| 10039434 |
| 10039435 |
+----------+
3 rows in set (4.31 sec)
mysql> select * from table limit 10000000,3 ;
+----------+-----------------------------+------------------------------+
| id | xxxxxxxx | xxxxxxxx |
+----------+-----------------------------+------------------------------+
| 10039433 | xxx xxx | xx |
| 10039434 | xxx xxx | xx |
| 10039435 | xxx xxx | xx |
+----------+-----------------------------+----------------------------+-+
3 rows in set (17.37 sec)
故對于大數(shù)據(jù)量limit可以分段操作权逗。
