Reserved word in column name - insert into MySQL

Question

I have a MySQL database with the word "group" in one of the column names. I can't change this database and column's name; it's not mine.

Table users, columns: id, name, password, group, and other. I need to insert a record into this table. I tried INSERT INTO users (name, group) VALUES ('John', '9'), but it's not working because of "group".

Can you help me, how to insert a record into this table, please?

I think some id or password or other may be mandatory.Once check it out. — Kiran, Mar 21 '12 at 07:43

score 32 · Answer 1 · answered Mar 21 '12 at 07:13

32

Try:

INSERT INTO users (`name`, `group`) VALUES ('John', '9')

answered Mar 21 '12 at 07:13

sikander

2,286
16
23

With backticks all is working now :-) – krYsti Mar 21 '12 at 09:00

score 21 · Answer 2 · edited Jun 16 '20 at 19:52

21

use backticks(`) around column names when you use reserved keywords in query:

INSERT INTO users (`name`,`group`) VALUES ('John', '9')

Read here: Reserved Words

edited Jun 16 '20 at 19:52

Phil Ross

25,590
9
67
77

answered Mar 21 '12 at 07:16

3

:) already updated. before you wrote. – Mar 21 '12 at 07:27

Reserved word in column name - insert into MySQL

2 Answers2

Linked

Related