Change column name

[bastienk]

is it possible?

i am trying

ALTER tester CHANGE  COLUMN  'Blah' 'blah'

Hints will be appreciated

TIA



Bastien

Cat, the other other white meat

 

[Chacalinc]

http://dev.mysql.com/doc/maxdb/en/85/b39098022c11d3a97d00a0c9449261/content.htm

 

[bastienk]

no joy...

RENAME COLUMN tester.Blah TO blah1

MySQL said:


#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLUMN tester.Blah TO blah1' at line 1


Bastien

Cat, the other other white meat

 

[TonyGroves]

Try:
[tt]
ALTER TABLE tester RENAME blah blah1
[/tt]

-----
ALTER world DROP injustice, ADD peace;

 

[bastienk]

nope...found success with


ALTER TABLE tester CHANGE Blah blah varchar(10);


Bastien

Cat, the other other white meat