列名中的保留字-插入MySQL [英] Reserved word in column name - insert into MySQL

问题描述

我有一个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')

这篇关于列名中的保留字-插入MySQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！