Hai all

I wonder actually whats wrong with this query?

mysql>ALTER TABLE distributors RENAME COLUMN city TO state

Mysql says syntax error.


Note:- I have loged on as Root.

MySQL is

ALTER TABLE tbl_name CHANGE old_col_name new_col_name columntype

Thanks Chrishirst

What should i specify for the columntype.
i executed like this
mysql>ALTER TABLE distributors CHANGE city TO state varchar(20);
Is this correct?

columntype should be either;

The same type as the column is;

or

A new type to change the column into (not recommended for populated tables)

so yes, your syntax is correct.

Thanks Chrishirst for the effort. it worked !!