为何我用SELECT...LIMIT查询出的结果是倒序的？从尾部开始计算顺序的呢？ 提前谢谢高手解惑，谢谢：
mysql> SELECT * FROM id4;
+----+-------+------+
| id | name | sex |
+----+-------+------+
| 1 | Diego | UN |
| 2 | Sam | M |
| 3 | Tom | F |
| 4 | Mark | UN |
| 5 | Kim | UN |
| 6 | Kate | F |
| 7 | Rose | F |
| 8 | Joe | UN |
+----+-------+------+
8 rows in set (0.00 sec)
mysql> SELECT id,name FROM id4 LIMIT 2,3;
+----+------+
| id | name |
+----+------+
| 6 | Kate |
| 5 | Kim |
| 4 | Mark |
+----+------+
3 rows in set (0.00 sec)
mysql> SELECT id,name FROM id4 LIMIT 2;
+----+-------+
| id | name |
+----+-------+
| 1 | Diego |
| 8 | Joe |
+----+-------+
2 rows in set (0.00 sec)
版权声明：本文为weixin_33917217原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。