Hello, I plan to reorder some columns of my table. So I am using ALTER TABLE STATEMENT .. with CHANGE syntax as suggested at:
http://dev.mysql.com/doc/mysql/en/ALTER_TABLE_problems.html I believe its the only way to reorder columns? Is there something better? If CHANGE is the best option, is there any version restriction for the statement or it works with all versions of MySQL? Currently I am using MySQL 4.1 where it works great but my host is still running 3.23.58 :( Regards, Karam __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]