MySQL分页方法

环境

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)

以上是小编为您精心准备的的内容，在的博客、问答、公众号、人物、课程等栏目也有的相关内容，欢迎继续使用右上角搜索按钮进行搜索mysql
， insert
， query
， test
， name
， values
OK
mysql分页查询语句、mysql 分页、mysql limit 分页、mysql 分页查询、mybatis mysql 分页，以便于您获取更多的相关知识。