Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What drive the natural result order for an unordered MySQL request

Tags:

database

mysql

How does mysql return lines when there is no ORDER BY in the request?

What drives the natural order?

There can obviously be many different queries but let's say a simple

select column from table where date < NOW()

like image 680
Nicolas Manzini Avatar asked Dec 29 '25 01:12

Nicolas Manzini


1 Answers

There is no natural predictable order when you don't specify one.

like image 64
juergen d Avatar answered Dec 30 '25 14:12

juergen d



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!