开发者

Maximum length of a table name in MySQL

What is the maximum length of a table name in MyS开发者_开发问答QL?


64 characters according to this.


It's 64 characters. The documentation shows these limits:

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


Names for databases, tables, columns, and indexes can be up to 64 characters long. Alias names can be up to 256 characters long.


Mysql Maximum length of characters for all identifier are 64 characters except Alias (256) and Compound Statement Lablel (16)
Check the whole list here

Maximum length of a table name in MySQL

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜