可以使用数字来命名MySQL表列吗​​? [英] Can a number be used to name a MySQL table column?

问题描述

我有一个表，其列名称如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.

错误总是伴随着:

您的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表列吗​​?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！