解决 MySQL 分页数据错乱重复
root@localhost >select * from glon ORDER BY create_time,id limit 0, 4;+----+--------------+---------------------+------+
| id | name | create_time | age|
+----+--------------+---------------------+------+
|1 | Eason Chan | 2017-05-02 08:10:10 | 19 |
|4 | Jacky Cheung | 2017-05-02 14:00:00 | 22 |
|5 | 周芷若 | 2017-05-02 14:00:00 | 16 |
|6 | Andy Lau | 2017-05-02 14:00:00 | 50 |
+----+--------------+---------------------+------+4 rows in set (0.00 sec)
root@localhost >select * from glon ORDER BY create_time,id limit 4, 4;
+----+-----------+---------------------+------+
| id | name | create_time | age|
+----+-----------+---------------------+------+
|7 | 至尊宝 | 2017-05-02 14:00:00 | 20 |
|8 | 刘三姐 | 2017-05-02 14:00:00 | 19 |
| 12 | 黄蓉 | 2017-05-03 08:10:10 | 19 |
|2 | Glon Ho | 2017-05-03 12:10:10 | 18 |
+----+-----------+---------------------+------+4 rows in set (0.00 sec)
root@localhost >select * from glon ORDER BY create_time,id limit 8, 4;
+----+--------+---------------------+------+
| id | name | create_time | age|
+----+--------+---------------------+------+
|9 | 乔峰 | 2017-05-03 13:10:10 | 22 |
|3 | 赵敏 | 2017-05-03 14:10:10 | 17 |
| 10 | 段誉 | 2017-05-03 15:10:10 | 19 |
| 11 | 郭靖 | 2017-05-03 17:10:10 | 20 |
+----+--------+---------------------+------+4 rows in set (0.00 sec)
root@localhost >select * from glon ORDER BY create_time,age limit 0, 4;
+----+------------+---------------------+------+
| id | name | create_time | age|
+----+------------+---------------------+------+
|1 | Eason Chan | 2017-05-02 08:10:10 | 19 |
|5 | 周芷若 | 2017-05-02 14:00:00 | 16 |
|8 | 刘三姐 | 2017-05-02 14:00:00 | 19 |
|7 | 至尊宝 | 2017-05-02 14:00:00 | 20 |
+----+------------+---------------------+------+4 rows in set (0.00 sec)
root@localhost >select * from glon ORDER BY create_time,age limit 4, 4;
+----+--------------+---------------------+------+
| id | name | create_time | age|
+----+--------------+---------------------+------+
|4 | Jacky Cheung | 2017-05-02 14:00:00 | 22 |
|6 | Andy Lau | 2017-05-02 14:00:00 | 50 |
| 12 | 黄蓉 | 2017-05-03 08:10:10 | 19 |
|2 | Glon Ho | 2017-05-03 12:10:10 | 18 |
+----+--------------+---------------------+------+4 rows in set (0.00 sec)
root@localhost >select * from glon ORDER BY create_time,age limit 8, 4;
+----+--------+---------------------+------+
| id | name | create_time | age|
+----+--------+---------------------+------+
|9 | 乔峰 | 2017-05-03 13:10:10 | 22 |
|3 | 赵敏 | 2017-05-03 14:10:10 | 17 |
| 10 | 段誉 | 2017-05-03 15:10:10 | 19 |
| 11 | 郭靖 | 2017-05-03 17:10:10 | 20 |
+----+--------+---------------------+------+4 rows in set (0.00 sec)
root@localhost >select * from glon ORDER BY age,id limit 0, 4;
+----+------------+---------------------+------+
| id | name | create_time | age|
+----+------------+---------------------+------+
|5 | 周芷若 | 2017-05-02 14:00:00 | 16 |
|3 | 赵敏 | 2017-05-03 14:10:10 | 17 |
|2 | Glon Ho | 2017-05-03 12:10:10 | 18 |
|1 | Eason Chan | 2017-05-02 08:10:10 | 19 |
+----+------------+---------------------+------+4 rows in set (0.00 sec)
root@localhost >select * from glon ORDER BY age,id limit 4, 4;
+----+-----------+---------------------+------+
| id | name | create_time | age|
+----+-----------+---------------------+------+
|8 | 刘三姐 | 2017-05-02 14:00:00 | 19 |
| 10 | 段誉 | 2017-05-03 15:10:10 | 19 |
| 12 | 黄蓉 | 2017-05-03 08:10:10 | 19 |
|7 | 至尊宝 | 2017-05-02 14:00:00 | 20 |
+----+-----------+---------------------+------+4 rows in set (0.00 sec)
root@localhost >select * from glon ORDER BY age,id limit 8, 4;
+----+--------------+---------------------+------+
| id | name | create_time | age|
+----+--------------+---------------------+------+
| 11 | 郭靖 | 2017-05-03 17:10:10 | 20 |
|4 | Jacky Cheung | 2017-05-02 14:00:00 | 22 |
|9 | 乔峰 | 2017-05-03 13:10:10 | 22 |
|6 | Andy Lau | 2017-05-02 14:00:00 | 50 |
+----+--------------+---------------------+------+4 rows in set (0.00 sec)
页:
[1]