Documentation Home
MySQL Internals Manual


MySQL Internals Manual  /  ...  /  Row Order Within Result Sets

26.6.4 Row Order Within Result Sets

Please keep in mind that the row order within a significant number of result sets depends on storage engine properties and in worst cases the current load (NDB!, partitioning?, parallel query?) on the testing box.

Either use

--sorted_result
SELECT * FROM t1;

or, if possible, "decorate" your SELECT with ORDER BY to make the row order static.


User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
Sign Up Login You must be logged in to post a comment.