记录没有索引的表的排序 [英] Record ordering for tables with no indices

问题描述

我很好奇在表上没有索引或约束的情况下MySQL如何进行内部记录排序.如果数据内容永不改变，相同的SELECT会始终以相同的顺序返回记录吗?还是可以期望随机排序?

I am curious how MySQL conducts internal record ordering in case there is no indices or constraints on a table. Provided that the data contents never change, will the same SELECT always return the records in the same order or can you expect shuffled ordering?

谢谢

推荐答案

您可以期待订单改组. ORDER BY至关重要.

You can expect order shuffling. ORDER BY is critical.

这篇关于记录没有索引的表的排序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！