本文介绍了列名中的保留字-插入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的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!