页次: 1
使用 limit
首先创建一个表
http://www.ipbbs.net/viewtopic.php?id=165
# 限制前两条
mysql> select * from goods limit 2; +------+--------+------+---------+ | g_id | g_name | v_id | g_price | +------+--------+------+---------+ | 1 | aaa | 1 | 1.10 | | 2 | aaa | 2 | 2.10 | +------+--------+------+---------+ 2 rows in set (0.00 sec) mysql> select * from goods limit 1, 4; +------+--------+------+---------+ | g_id | g_name | v_id | g_price | +------+--------+------+---------+ | 2 | aaa | 2 | 2.10 | | 3 | aaa | 3 | 3.10 | | 4 | bbb | 1 | 4.10 | | 5 | bbb | 2 | 5.10 | +------+--------+------+---------+ 4 rows in set (0.00 sec)
获得四条,从第二条开始
ipbbs.net
离线
页次: 1