-- 从第0个位置开始取,取3条记录
mysql> select * from stu limit 0,3;
-- 从第2个位置开始取,取3条记录
mysql> select * from stu limit 2,3;
代码运行输出结果如下:
- +--------+----------+--------+--------+---------+------------+------+------+
- | stuNo | stuName | stuSex | stuAge | stuSeat | stuAddress | ch | math |
- +--------+----------+--------+--------+---------+------------+------+------+
- | s25303 | 李斯文 | 女 | 22 | 2 | 北京 | 55 | 82 |
- | s25304 | 欧阳俊雄 | 男 | 28 | 4 | 天津 | NULL | 74 |
- | s25305 | 诸葛丽丽 | 女 | 23 | 7 | 河南 | 72 | 56 |
- +--------+----------+--------+--------+---------+------------+------+------+
- 3 rows in set (0.00 sec)
复制代码 起始位置可以省略,默认是从0开始
- mysql> select * from stu limit 3;
- +--------+---------+--------+--------+---------+------------+------+------+
- | stuNo | stuName | stuSex | stuAge | stuSeat | stuAddress | ch | math |
- +--------+---------+--------+--------+---------+------------+------+------+
- | s25301 | 张秋丽 | 男 | 18 | 1 | 北京 | 80 | NULL |
- | s25302 | 李文才 | 男 | 31 | 3 | 上海 | 77 | 76 |
- | s25303 | 李斯文 | 女 | 22 | 2 | 北京 | 55 | 82 |
- +--------+---------+--------+--------+---------+------------+------+------+
- 3 rows in set (0.00 sec)
复制代码
|
|