In mysql, limit is not used in mysql. Instead, it is replaced by the limit keyword. The usage is as follows: 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)