@Marked-mysql的limit参数

mysql> select * from tuser;
+---------+-----------+----------+
| user_id | user_name | group_id |
+---------+-----------+----------+
|       1 | NULL      |        1 |
|       2 | 小任      |        1 |
|       3 | 小于      |        1 |
|       4 | 周全      |        2 |
|       5 | 汉克      |        2 |
|       6 | 老姜      |        2 |
|      16 | 周通      |        1 |
|      17 | 东邪      |        1 |
|      18 | 老顽童    |        1 |
+---------+-----------+----------+

 select * from tuser limit 0,5;

mysql> select * from tuser limit 0,5;
+---------+-----------+----------+
| user_id | user_name | group_id |
+---------+-----------+----------+
|       1 | NULL      |        1 |
|       2 | 小任      |        1 |
|       3 | 小于      |        1 |
|       4 | 周全      |        2 |
|       5 | 汉克      |        2 |
+---------+-----------+----------+
5 rows in set

 
select * from tuser limit 下标[0开始],[个数];

limit的第一个参数是下标，第二个参数是取记录个数。

备注！