ALTER TABLE....with CHANGE syntax

Hello, Can somebody tell me from which version of MySQL is - ALTER TABLECHANGE... syntax supported. Regards, Karam __ Do you Yahoo!? Yahoo! Mail - Easier than ever with enhanced search. Learn more. http://info.mail.yahoo.com/mail_250

Re: ALTER TABLE....with CHANGE syntax

Which version are you running. Quite often when you see a 'check the version you are running' message indicates a syntax error in your mySQL statement.. Andy On Tue, 2005-01-11 at 05:13 -0800, Karam Chand wrote: Hello, Can somebody tell me from which version of MySQL is - ALTER TABLE

Re: ALTER TABLE....with CHANGE syntax

are running' message indicates a syntax error in your mySQL statement.. Andy On Tue, 2005-01-11 at 05:13 -0800, Karam Chand wrote: Hello, Can somebody tell me from which version of MySQL is - ALTER TABLECHANGE... syntax supported. Regards, Karam

ALTER TABLE....with CHANGE syntax

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