Documentation Home
MySQL Internals Manual
Download this Manual
EPUB - 1.2Mb


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
Sign Up Login You must be logged in to post a comment.