MySQL 5.7 LIMIT语句介绍
发布时间：2022-03-21 11:53:44 所属栏目：MySql教程 来源：互联网
导读：LIMIT语句可以限制SELECT语句返回的行数。LIMIT使用1个或2个参数，参数必须是非负数的整数。 mysql select * from dept2 order by 1; +--------+-------+ | deptno | dname | +--------+-------+ | 10 | A | | 20 | B | | 30 | C | | 40 | D | | 50 | E | |
|
LIMIT语句可以限制SELECT语句返回的行数。LIMIT使用1个或2个参数，参数必须是非负数的整数。 mysql> select * from dept2 order by 1; +--------+-------+ | deptno | dname | +--------+-------+ | 10 | A | | 20 | B | | 30 | C | | 40 | D | | 50 | E | | 60 | F | | 70 | G | | 80 | H | | 90 | I | | 100 | J | | 110 | K | | 120 | L | | 130 | M | | 140 | N | | 150 | O | | 160 | P | | 170 | Q | | 180 | R | | 190 | S | | 200 | T | +--------+-------+ 20 rows in set (0.03 sec) --返回第6-15行 mysql> select * from dept2 order by 1 limit 5,10; +--------+-------+ | deptno | dname | +--------+-------+ | 60 | F | | 70 | G | | 80 | H | | 90 | I | | 100 | J | | 110 | K | | 120 | L | | 130 | M | | 140 | N | | 150 | O | +--------+-------+ 10 rows in set (0.00 sec) --返回前5行 mysql> select * from dept2 order by 1 limit 5; +--------+-------+ | deptno | dname | +--------+-------+ | 10 | A | | 20 | B | | 30 | C | | 40 | D | | 50 | E | +--------+-------+ 5 rows in set (0.00 sec) mysql> select * from dept2 order by 1 limit 0,5; +--------+-------+ | deptno | dname | +--------+-------+ | 10 | A | | 20 | B | | 30 | C | | 40 | D | | 50 | E | +--------+-------+ 5 rows in set (0.00 sec) （编辑：ASP站长） 【免责声明】本站内容转载自互联网，其相关言论仅代表作者个人观点绝非权威，不代表本站立场。如您发现内容存在版权问题，请提交相关链接至邮箱：bqsm@foxmail.com，我们将及时予以处理。 |
相关内容
未处理完善
-
无相关信息
最新更新