SQL:查询的默认排序依据是什么?
不使用ORDER BY时查询的默认顺序是什么?
What is the default order of a query when no ORDER BY is used?
推荐答案
目前没有这样的订单.取自 http://forums.mysql.com/read.php?21,239471,239688#msg-239688
There is no such order present. Taken from http://forums.mysql.com/read.php?21,239471,239688#msg-239688
当 ORDER BY 缺失时，不要依赖顺序.
Do not depend on order when ORDER BY is missing.
如果您想要特定的订单，请始终指定 ORDER BY - 在某些情况下，引擎可以消除 ORDER BY，因为它是做一些其他的步骤.
Always specify ORDER BY if you want a particular order -- in some situations the engine can eliminate the ORDER BY because of how it does some other step.
SELECT * FROM tbl -- 这将执行表扫描".如果表有从来没有任何 DELETEs/REPLACEs/UPDATEs，记录将恰好是在插入顺序中，因此您观察到了什么.
SELECT * FROM tbl -- this will do a "table scan". If the table has
never had any DELETEs/REPLACEs/UPDATEs, the records will happen to be
in the insertion order, hence what you observed.
如果您对 InnoDB 表执行相同的语句，它们会已按 PRIMARY KEY 顺序交付，而不是 INSERT 顺序.再次，这是底层实现的产物，而不是取决于.
If you had done the same statement with an InnoDB table, they would have been delivered in PRIMARY KEY order, not INSERT order. Again, this is an artifact of the underlying implementation, not something to depend on.
相关文章