Mysql limit使用

Useage: select _column,_column from _table [where Clause] [limit N][offset M]

• select * : 返回所有记录
• limit N : 返回 N 条记录
• offset M : 跳过 M 条记录, 默认 M=0, 单独使用似乎不起作用
• limit N,M : 相当于 limit M offset N , 从第 N 条记录开始, 返回 M 条记录

mysql> select * from t1;
+------+
| id   |
+------+
|    1 |
|    2 |
|    3 |
|    4 |
|    5 |
|    6 |
|    7 |
+------+
7 rows in set (0.00 sec)

mysql> select * from t1 limit 3;
+------+
| id   |
+------+
|    1 |
|    2 |
|    3 |
+------+
3 rows in set (0.00 sec)

mysql> select * from t1 limit 3,2;
+------+
| id   |
+------+
|    4 |
|    5 |
+------+
2 rows in set (0.00 sec)

mysql>
mysql> select * from t1 limit 3 offset 2;
+------+
| id   |
+------+
|    3 |
|    4 |
|    5 |
+------+
3 rows in set (0.00 sec)

mysql> select * from t1 limit 2 offset 3;
+------+
| id   |
+------+
|    4 |
|    5 |
+------+
2 rows in set (0.00 sec)