问题描述
我有一个表，其列名有 25、50、100 等.
I have a table that has column names like 25, 50, 100, etc..
尝试更新表格时，无论我如何操作，都会出现错误
When trying to update the table I get an error, no matter how I do it
UPDATE table SET '25'='100' WHERE id = '1'
我尝试过以任何方式引用和反引号，但没有成功.
I have tried quoting and backticking every which way but without success.
错误总是沿着以下路线:
The error is always along the lines of:
您的 SQL 语法有错误；检查与您的 MySQL 服务器版本相对应的手册，以获取在第 1 行的25"=100 WHERE id=1' 附近使用的正确语法
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''25'=100 WHERE id=1' at line 1
如果我将列名更改为 twentyfive - 我没有问题，但这不是我想要的.是否可以使用数字作为列名?
If I change the column name to twentyfive - I don't have a problem, but that's not what I want. Is it possible to use a number as a column name?
推荐答案
来自 文档:
标识符可以以数字开头，但除非引用，否则不能仅由数字组成.
Identifiers may begin with a digit but unless quoted may not consist solely of digits.
这意味着你必须用反勾号来引用它，比如25":
Which means you must quote it with back ticks like `25`:
UPDATE table SET `25`='100' WHERE id='1'
这篇关于可以使用数字来命名 MySQL 表列吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！