Reserved word in column name - insert into MySQL [

问题:

This question already has an answer here:

• Syntax error due to using a reserved word as a table or column name in MySQL 1 answer

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?

回答1:

Try:

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

回答2:

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

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

Read here: Reserved Words