mysql 去掉默认排序_Mysql 内部默认排序

最新推荐文章于 2023-02-06 15:49:13 发布

weixin_39608748

最新推荐文章于 2023-02-06 15:49:13 发布

阅读量317

点赞数

文章标签： mysql 去掉默认排序

本文链接：https://blog.csdn.net/weixin_39608748/article/details/113595814

版权

mysql默认的排序：

https://forums.mysql.com/read.php?21,239471,239688#msg-239688

Do not depend on order when ORDER BY is missing.

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.

GROUP BY forces ORDER BY. (This is a violation of the standard. It can be avoided by using ORDER BY NULL.)

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.

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.

https://stackoverflow.com/questions/8746519/sql-what-is-the-default-order-by-of-queries

原文：https://www.cnblogs.com/cbugs/p/9279699.html