LIMIT用来返回SELECT语句的行数。LIMIT取1个或2个数字参数,如果给定2个参数,第一个指定要返回的第一行的偏移量,第二个指定返回行的最大数目。初始行的偏移量是0(不是1)。
实例:stockout_order 表中共有350w的数据,分别查询第3K条数据和第30W条。
当数据量大于10w时,
<span style="font-size:12px;">mysql> select count(1) from stockout_order;
+----------+
| count(1) |
+----------+
| 3545570 |
+----------+
1 row in set (0.54 sec)</span>
select stockout_no from stockout_order limit 3000,1;
<span style="font-size:12px;">mysql> select stockout_no from stockout_order limit 3000,1;
+----------------+
| stockout_no |
+----------------+
| CK201409213726 |
+----------------+
1 row in set (0.00 sec)</span>
select stockout_no from stockout_order where stockout_id >=3000 limit 1;
mysql> select stockout_no from stockout_order where stockout_id >=3000 limit 1;
+----------------+
| stockout_no |
+----------------+
| CK201409202895 |
+----------------+
1 row in set (0.01 sec)
select stockout_no from stockout_order limit 3000000,1;
mysql> select stockout_no from stockout_order limit 3000000,1;
+---------------+
| stockout_no |
+---------------+
| CK20150803580 |
+---------------+
1 row in set (2.06 sec)
select stockout_no from stockout_order where stockout_id >3000000 limit 1;
mysql> select stockout_no from stockout_order where stockout_id >=3000000 limit 1;
+----------------+
| stockout_no |
+----------------+
| CK201508022484 |
+----------------+
1 row in set (0.01 sec)
http://www.server110.com/mysql/201310/2228.html