列名中的保留字 - 插入 MySQL

2022-01-09 00:00:00 insert mysql reserved-words

我有一个 MySQL 数据库,其中一个列名中包含group"一词.我无法更改此数据库和列的名称;这不是我的.

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.

表用户、列:id、name、password、group、等.我需要在这个表中插入一条记录.我尝试了 INSERT INTO users (name, group) VALUES ('John', '9'),但由于group"而无法正常工作.

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?

推荐答案

试试:

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

相关文章