Rename a mysql column

[NevadaJones]

I searched but could not find this. Also I mistakenly posted this first in the PHP forum and can't delete it.

What is the syntax to rename a table column in a MySql database? I am trying this but it is not right.

ALTER table
CHANGE oldcolumn_name
newcolumn_name
CHAR(30)

 

[sleipnir214]

Have you looked at MySQL's online documentation? At

http://dev.mysql.com/doc/refman/5.0/en/alter-table.html

?

At the very least, the query will have to begin:

ALTER TABLE tablename


Want the best answers? Ask the best questions! TANSTAAFL!

 

[NevadaJones]

Thanks for the hint. The syntax is:

ALTER TABLE tablename
CHANGE oldcolumnname
newcolmnname
definition