偶然发现的mysql排序问题 如有如下的这么一张表
select * from t;
+----+------+-------+---------------------+
| id | name | price | create_time |
+----+------+-------+---------------------+
| 1 | a | 1 | 2016-03-16 14:15:37 |
| 2 | b | 1 | 2016-03-16 14:15:42 |
| 3 | c | 1 | 2016-03-16 14:15:45 |
| 4 | d | 1 | 2016-03-16 14:15:47 |
| 5 | e | 1 | 2016-03-16 14:15:51 |
| 6 | f | 1 | 2016-03-16 14:15:54 |
| 7 | g | 1 | 2016-03-16 14:15:56 |
| 8 | h | 1 | 2016-03-16 14:15:59 |
| 9 | i | 1 | 2016-03-16 14:16:04 |
| 10 | j | 1 | 2016-03-16 14:16:07 |
| 11 | k | 1 | 2016-03-16 14:16:11 |
+----+------+-------+---------------------+
#第一页
select * from t order by price limit 0,5;
+----+------+-------+---------------------+
| id | name | price | create_time |
+----+------+-------+---------------------+
| 11 | k | 1 | 2016-03-16 14:16:11 |
| 2 | b | 1 | 2016-03-16 14:15:42 |
| 3 | c | 1 | 2016-03-16 14:15:45 |
| 4 | d | 1 | 2016-03-16 14:15:47 |
| 5 | e | 1 | 2016-03-16 14:15:51 |
+----+------+-------+---------------------+
#第二页 b、c、d、e 在第二页中重复出现了
select * from t order by price limit 5,5;
+----+------+-------+---------------------+
| id | name | price | create_time |
+----+------+-------+---------------------+
| 6 | f | 1 | 2016-03-16 14:15:54 |
| 5 | e | 1 | 2016-03-16 14:15:51 |
| 4 | d | 1 | 2016-03-16 14:15:47 |
| 3 | c | 1 | 2016-03-16 14:15:45 |
| 2 | b | 1 | 2016-03-16 14:15:42 |
+----+------+-------+---------------------+
似乎按照某一字段排序, 且许多记录存在相同的取值的话, mysql似乎会随机排序, 于是就会出现上述现象, 某些记录重复出现在不同页中。