change name of one column

MySQL Hi, I would like to change the name of one column of a table. I did: ALTER TABLE name_table ALTER COLUMN old_column RENAME new_column but it did not work due to don't understand a RENAME after ALTER COLUMN. Could someone help me? Thanks a lot

Re: change name of one column

javier, Wednesday, August 14, 2002, 12:51:10 PM, you wrote: Hi, I would like to change the name of one column of a table. I did: ALTER TABLE name_table ALTER COLUMN old_column RENAME new_column but it did not work due to don't understand a RENAME after ALTER COLUMN. Could someone