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
精彩评论