how to rename a two-word(for example; 'manager id') column name in MySQL

Question

i tried using this code below ALTER TABLE table_name change "MANAGER ID" TO manager_id;

error message received: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"MANAGER ID" TO manager_id' at line 1 0.000 sec

score 1 · Accepted Answer · answered Jan 25 '22 at 08:16

1

Correct syntax is:

ALTER TABLE table_name RENAME COLUMN `MANAGER ID` TO manager_id;

answered Jan 25 '22 at 08:16

Zakaria

4,715
2
5
31

1

thank you zakaria – Ukamaka Jan 25 '22 at 15:27

score 0 · Answer 2 · answered Jan 25 '22 at 08:17

0

According to this question and answer your are using the wrong quotes. It should be

`MANAGER ID`

how to rename a two-word(for example; 'manager id') column name in MySQL

2 Answers2