Reserved word in column name - insert into MySQL

mysql insert reserved-words
krYsti picture krYsti · Mar 21, 2012 · Viewed 28.8k times · Source

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?

Answer

sikander picture sikander · Mar 21, 2012

Try:

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

Related questions

"INSERT IGNORE" vs "INSERT ... ON DUPLICATE KEY UPDATE"

While executing an INSERT statement with many rows, I want to skip duplicate entries that would otherwise cause failure. After some research, my options appear to be the use of either: ON DUPLICATE KEY UPDATE which implies an unnecessary update …

Read More
How to set initial value and auto increment in MySQL?

How do I set the initial value for an "id" column in a MySQL table that start from 1001? I want to do an insert "INSERT INTO users (name, email) VALUES ('{$name}', '{$email}')"; Without specifying the initial …

Read More
How to copy a row and insert in same table with a autoincrement field in MySQL?

In MySQL I am trying to copy a row with an autoincrement column ID=1 and insert the data into same table as a new row with column ID=2. How can I do this in a single query?

Read More