mysql中limit的使用
mysql中沒有top,替而代之的是limit關鍵字,具體使用方法如下:
mysql> select * from test;
www.2cto.com
+----+------+-----+----------+--------------+
| 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)
www.2cto.com
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 |
+----+------+-----+----------+--------------+
www.2cto.com
3 rows in set (0.00 sec)