MySQL Forums
Forum List  »  Newbie

Re: mysql not ordering by correct column
Posted by: Phillip Ward
Date: November 11, 2015 06:27AM

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.

Options: ReplyQuote


Subject
Written By
Posted
Re: mysql not ordering by correct column
November 11, 2015 06:27AM


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.