Re: ALTER TABLE....with CHANGE syntax

2005-01-11 Thread Karam Chand
Hello, I am using 4.1.7 and it works for it. I just wanted to know from which version it support has started because it does not run on my 3.23.58 server. Regards, Karam --- Andy Ford <[EMAIL PROTECTED]> wrote: > Which version are you running. Quite often when you > see a 'check the > version y

Re: ALTER TABLE....with CHANGE syntax

2005-01-11 Thread Andy Ford
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

ALTER TABLE....with CHANGE syntax

2005-01-11 Thread Karam Chand
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 --

ALTER TABLE....with CHANGE syntax

2005-01-10 Thread Karam Chand
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 th