MySQL 中表名的最大长度

在 MySQL 中表名的最大长度是多少？

mysql

64418 次浏览

小开

最佳答案

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