Re: mysql not ordering by correct column
It's happening because that's what MySQl "feels" like doing, just at the moment.
There probably are algorithms and patterns that describe why it "chooses" to do things a particular way at a particular point in time but, IMHO, you should not concern yourself with them because they can change at any time or be fundamentally modified with any new release of the software.
Bottom line? Rows are stored in whatever order MySQL wants to store them and you cannot reliably influence it, nor should you try to.
"Order by" is your only option.
Regards, Phill W.
Subject
Written By
Posted
November 10, 2015 08:47AM
November 10, 2015 08:54AM
November 10, 2015 10:30AM
November 11, 2015 12:44AM
Re: mysql not ordering by correct column
November 11, 2015 06:27AM
November 11, 2015 11:25AM
December 01, 2015 08:11PM
December 01, 2015 09:36PM
December 02, 2015 05:00AM
November 11, 2015 12:45AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.