MySQL MySQL中表名的最大长度
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/6868302/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Maximum length of a table name in MySQL
提问by sniper
What is the maximum length of a table name in MySQL?
MySQL中表名的最大长度是多少？
回答by Bohemian
It's 64 characters. The documentationshows these limits:
它是 64 个字符。该文件显示了这些限制：
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
回答by Logicbomb
Names for databases, tables, columns, and indexes can be up to 64 characters long. Alias names can be up to 256 characters long.
数据库、表、列和索引的名称最长可达 64 个字符。别名最长可达 256 个字符。
回答by Bibhudatta Sahoo
Mysql Maximum length of characters for all identifier are 64 charactersexcept Alias (256)and Compound Statement Lablel (16)
Check the whole list here
Mysql 所有标识符的最大字符长度为64 个字符，除了别名 (256)和复合语句标签 (16)
在此处查看整个列表
