How to rename a column in MySQL

Question

I am trying to rename a column in a table in my DB. I already tried

ALTER TABLE TableName RENAME COLUMN OldColumnName TO NewColumnName

and i am getting an error reply saying - You have an error in your SQL syntax; Please whats the right syntax for this? Thanks.

See the manual for the syntax for modifying column details in MySQL — Strawberry, Feb 29 '20 at 07:41
Does this answer your question? [Rename a column in MySQL](https://stackoverflow.com/questions/30290880/rename-a-column-in-mysql) — Nigel Ren, Feb 29 '20 at 07:42
Alternatively, it might help if you provided the actual error. Note that you cannot rename a column to be a reserved word. — Strawberry, Feb 29 '20 at 07:44

score 4 · Accepted Answer · answered Feb 29 '20 at 07:42

4

Try using this syntax:

ALTER TABLE TableName CHANGE OldColumnName NewColumnName varchar(10) ;

answered Feb 29 '20 at 07:42

Jirka Vrba

1 Answers1