Probably a LAME question...

[XGuy]

Hello yet again everyone,

I have a simple, yet seemingly too simple question:I know that you can rename tables in a MySQL database with the ALTER TABLE statement...but can you rename a column somehow? Or do you have to drop it and re-add it? I really don't want to do that, but I will if I absolutely have to.

Cheers,

XGuy.

[DR_LaRRY_PEpPeR]

sure there is. you do have to redifine the column though when you rename it. (it's not dropped though, so you won't lose data). from the MySQL manual: http://www.mysql.com/documentation/m...ml#ALTER_TABLE

You can rename a column using a CHANGE old_col_name create_definition clause. To do so, specify the old and new column names and the type that the column currently has. For example, to rename an INTEGER column from a to b, you can do this:

mysql> ALTER TABLE t1 CHANGE a b INTEGER;

[XGuy]

Thanks!!