mysql中limit的使用_MySQL
程序员文章站
2022-05-21 13:11:18
...
bitsCN.com
mysql中limit的使用 mysql中没有top，替而代之的是limit关键字，具体使用方法如下： mysql> select * from test; +----+------+-----+----------+--------------+ | id | name | age | tel | address | +----+------+-----+----------+--------------+ | 1 | aaaa | 12 | aaaaaa | aaaaaaaaa | | 2 | bbbb | 12 | 12312312 | asgdsf | | 3 | bbb | 23 | 123423 | asdfsafd | | 5 | asdf | 23 | asfdsd | asdgesadg | | 7 | sadf | 23 | asgsdg | asgsdfsafsdf | +----+------+-----+----------+--------------+ 5 rows in set (0.00 sec) mysql> select * from test limit 2,5 -> ;+----+------+-----+--------+--------------+ | id | name | age | tel | address | +----+------+-----+--------+--------------+ | 3 | bbb | 23 | 123423 | asdfsafd | | 5 | asdf | 23 | asfdsd | asdgesadg | | 7 | sadf | 23 | asgsdg | asgsdfsafsdf | +----+------+-----+--------+--------------+ 3 rows in set (0.00 sec) mysql> select * from test limit 2,4; +----+------+-----+--------+--------------+ | id | name | age | tel | address | +----+------+-----+--------+--------------+ | 3 | bbb | 23 | 123423 | asdfsafd | | 5 | asdf | 23 | asfdsd | asdgesadg | | 7 | sadf | 23 | asgsdg | asgsdfsafsdf | +----+------+-----+--------+--------------+ 3 rows in set (0.00 sec) mysql> select * from test order by name limit 2,4; +----+------+-----+----------+--------------+ | id | name | age | tel | address | +----+------+-----+----------+--------------+ | 3 | bbb | 23 | 123423 | asdfsafd | | 2 | bbbb | 12 | 12312312 | asgdsf | | 7 | sadf | 23 | asgsdg | asgsdfsafsdf | +----+------+-----+----------+--------------+ 3 rows in set (0.00 sec) bitsCN.com
mysql中limit的使用 mysql中没有top，替而代之的是limit关键字，具体使用方法如下： mysql> select * from test; +----+------+-----+----------+--------------+ | id | name | age | tel | address | +----+------+-----+----------+--------------+ | 1 | aaaa | 12 | aaaaaa | aaaaaaaaa | | 2 | bbbb | 12 | 12312312 | asgdsf | | 3 | bbb | 23 | 123423 | asdfsafd | | 5 | asdf | 23 | asfdsd | asdgesadg | | 7 | sadf | 23 | asgsdg | asgsdfsafsdf | +----+------+-----+----------+--------------+ 5 rows in set (0.00 sec) mysql> select * from test limit 2,5 -> ;+----+------+-----+--------+--------------+ | id | name | age | tel | address | +----+------+-----+--------+--------------+ | 3 | bbb | 23 | 123423 | asdfsafd | | 5 | asdf | 23 | asfdsd | asdgesadg | | 7 | sadf | 23 | asgsdg | asgsdfsafsdf | +----+------+-----+--------+--------------+ 3 rows in set (0.00 sec) mysql> select * from test limit 2,4; +----+------+-----+--------+--------------+ | id | name | age | tel | address | +----+------+-----+--------+--------------+ | 3 | bbb | 23 | 123423 | asdfsafd | | 5 | asdf | 23 | asfdsd | asdgesadg | | 7 | sadf | 23 | asgsdg | asgsdfsafsdf | +----+------+-----+--------+--------------+ 3 rows in set (0.00 sec) mysql> select * from test order by name limit 2,4; +----+------+-----+----------+--------------+ | id | name | age | tel | address | +----+------+-----+----------+--------------+ | 3 | bbb | 23 | 123423 | asdfsafd | | 2 | bbbb | 12 | 12312312 | asgdsf | | 7 | sadf | 23 | asgsdg | asgsdfsafsdf | +----+------+-----+----------+--------------+ 3 rows in set (0.00 sec) bitsCN.com