环境
MySQL 5.1 + 命令行工具
问题
MySQL分页
解决
--创建测试表
create table test
(
id int(11) primary key auto_increment,
name varchar(20) not null
);
--插入数据
mysql> insert into test(name) values('test1');
Query OK, 1 row affected (0.16 sec)
mysql> insert into test(name) values('test2');
Query OK, 1 row affected (0.01 sec)
mysql> insert into test(name) values('test3');
Query OK, 1 row affected (0.00 sec)
mysql> insert into test(name) values('test4');
Query OK, 1 row affected (0.00 sec)
mysql> insert into test(name) values('test5');
Query OK, 1 row affected (0.03 sec)
mysql> insert into test(name) values('test6