环境 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 i
环境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');query ok, 1 row affected (0.01 sec)mysql> insert into test(name) values('test7');query ok, 1 row affected (0.06 sec)mysql> insert into test(name) values('test8');query ok, 1 row affected (0.00 sec)mysql> insert into test(name) values('test9');query ok, 1 row affected (0.01 sec)mysql> insert into test(name) values('test10');query ok, 1 row affected (0.01 sec)--执行分页mysql> select id,name from test limit 0,10;+----+--------+| id | name |+----+--------+| 1 | test1 || 2 | test2 || 3 | test3 || 4 | test4 || 5 | test5 || 6 | test6 || 7 | test7 || 8 | test8 || 9 | test9 || 10 | test10 |+----+--------+10 rows in set (0.00 sec)
运行效果截图
小技巧 
快速插入数据：
insert into test(name) select name from test;
详情参考此文：在mysql中快速复制数据表方法汇总
http://blog.csdn.net/btbdylq/article/details/6827981
总结语法 
select id,name from test limit参数1,参数2;
参数1，从第几条开始
参数2，返回多少条数据
javaweb中实现分页算法
select * from tablename limit (pagenow-1)*pagesize,pagesize
pagenow：当前第几页
pagesize：每页显示的记录数
参考资料http://zhidao.baidu.com/question/248872252.html
http://zhidao.baidu.com/question/159608774.html