Re: ALTER TABLE....with CHANGE syntax
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 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 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 > > > -- > perl -e "print qq^bIG VeRN ! ^^qq^#'#Yv#= > This e-mail is private and may be confidential and > is for the intended recipient only. If misdirected, > please notify us by telephone and confirm that it > has been deleted from your system and any copies > destroyed. If you are not the intended recipient > you are strictly prohibited from using, printing, > copying, distributing or disseminating this e-mail > or any information contained in it. We use > reasonable endeavours to virus scan all e-mails > leaving the Company but no warranty is given that > this e-mail and any attachments are virus free. You > should undertake your own virus checking. The right > to monitor e-mail communications through our network > is reserved by us. > > > __ 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]
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 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 > -- perl -e "print qq^bIG VeRN ! ^^qq^#'#Yv#=http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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, 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]
