mysql 分页查询
语法
select 列
from 表
【join type] join on 连接条件
where 筛选条件
group by 分组字段
having 分组后筛选
order by 排序字段
limit offset, size;
分页实例
select * from student limit 0,3;
+----+--------+------+------+----------+--------+
| id | name | sex | age | class_id | status |
+----+--------+------+------+----------+--------+
| 1 | 张三 | 男 | 18 | 1 | 1 |
| 2 | 王五 | 男 | 20 | 1 | 1 |
| 3 | 李四 | 男 | 20 | 1 | 1 |
+----+--------+------+------+----------+--------+
3 rows in set (0.00 sec)
select * from student limit 3,3;
+----+------------+------+------+----------+--------+
| id | name | sex | age | class_id | status |
+----+------------+------+------+----------+--------+
| 4 | 小红 | 女 | 23 | 2 | 1 |
| 5 | 小花 | 女 | 19 | 2 | 1 |
| 6 | huyongjian | man | 18 | 3 | 1 |
+----+------------+------+------+----------+--------+
3 rows in set (0.00 sec)
分页实例
select * from student where `class_id`=1 order by sex desc limit 0,3;
+----+--------+------+------+----------+--------+
| id | name | sex | age | class_id | status |
+----+--------+------+------+----------+--------+
| 1 | 张三 | 男 | 18 | 1 | 1 |
| 2 | 王五 | 男 | 20 | 1 | 1 |
| 3 | 李四 | 男 | 20 | 1 | 1 |
+----+--------+------+------+----------+--------+
3 rows in set (0.00 sec)
select * from student where `class_id`=1 order by sex desc limit 3,3;
+----+------------+------+------+----------+--------+
| id | name | sex | age | class_id | status |
+----+------------+------+------+----------+--------+
| 4 | 小红 | 女 | 23 | 1 | 1 |
| 5 | 小花 | 女 | 19 | 1 | 1 |
| 6 | huyongjian | man | 18 | 1 | 1 |
+----+------------+------+------+----------+--------+
3 rows in set (0.00 sec)