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的第一个参数是下标,第二个参数是取记录个数。
备注!