MySQL 5.7 LIMIT语句介绍
发布时间：2022-03-21 11:05:08 所属栏目：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) （编辑：大连站长网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
站长推荐