mysql中limit的使用_MySQL

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