Mysql change column name from "group" to "group_code"

Question

I have set a column name to "group", which turned out to be a reserved word. Now I try to change the name to "group_code", but I get an error. I try:

ALTER TABLE task_values CHANGE group group_code VARCHAR(40) NOT NULL;

and

ALTER TABLE task_values CHANGE 'group' group_code VARCHAR(40) NOT NULL;

but both fail, I get "No such element" error. Please help

Fabio · Accepted Answer · 2014-03-19 21:03:46Z

2

You will need to use backticks around group which, as you said, is a mysql reserved keyword

ALTER TABLE task_values CHANGE `group` group_code VARCHAR(40) NOT NULL;

answered Mar 19, 2014 at 21:03

Fabio

23.5k12 gold badges57 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1