MySQL Forums
Forum List  »  Newbie

Re: alter table move column syntax error
Posted by: Phillip Ward
Date: July 01, 2014 05:32AM

A couple of Home Truths about any DBMS worth its salt, including MySQL.

Column order does not matter.

Some types of data field are split off from the main record structure so physical order isn't guaranteed.
If you want columns in a particular order, specify that order in your select statement(s). "Select *" should, IMHO, only be used for manual, diagnostic work, and not for production applications.


Row order does not matter.

Your database will store rows in whatever order it feels is most efficient for it to work with them.
If you want rows in a particular order, use an "order by" clause.

Regards, Phill W.

Options: ReplyQuote


Subject
Written By
Posted
Re: alter table move column syntax error
July 01, 2014 05:32AM


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.