MySQL中列名的最大长度。

I am working with mysql and have a column name with length 70.
So, I am getting error which states that the column name is too long.
Now, I just want to know what is the maximum length of column name in mysql?

我正在使用mysql，并有一个长度为70的列名。因此，我得到了一个错误，表明列名太长。现在，我想知道mysql中列名的最大长度是多少?

7 个解决方案

#1

Similar question is already answered Here
Anyway, Maximum allowed length of column name is 64 according to documentation : Mysql Documentation

类似的问题已经在这里得到了回答，根据文档:Mysql文档，列名的最大允许长度是64

#2

The following table describes the maximum length for each type of identifier.

下表描述了每种类型的标识符的最大长度。

Identifier                      Maximum Length (characters)
Database                        64
Table                           64
Column                          64
Index                           64
Constraint                      64
Stored Procedure or Function    64
Trigger                         64
View                            64
Alias                           256 
Compound Statement Label        16

#3

According to this, the max length is 64

根据这个，最大长度是64

#4

64 Characters in MySQL 5.0

MySQL 5.0中的64个字符

Ref : http://dev.mysql.com/doc/refman/5.0/en/identifiers.html

裁判:http://dev.mysql.com/doc/refman/5.0/en/identifiers.html

#5

It's 64 characters max in current version - http://dev.mysql.com/doc/refman/5.0/en/identifiers.html

目前的版本是最多64个字符——http://dev.mysql.com/doc/refman/5.0/en/identifiers.html

#6

Per the documentation, the maximum length for a column name is: 64 characters.

根据文档，列名的最大长度是:64个字符。

#7

it is 64 in MySQL 5.0, you can check documentation about here

在MySQL 5.0中是64，你可以在这里查看文档。

#1