参考文献:https://dev.mysql.com/doc/refman/8.0/en/identifiers.html
Identifier Type | Maximum Length (characters) |
---|---|
Database | 64 (NDB storage engine: 63) |
Table | 64 (NDB storage engine: 63) |
Column | 64 |
Index | 64 |
Constraint | 64 |
Stored Program | 64 |
View | 64 |
Tablespace | 64 |
Server | 64 |
Log File Group | 64 |
Alias | 256 (see exception following table) |
Compound Statement Label | 16 |
User-Defined Variable | 64 |
Resource Group | 64 |
附:其他数据库
数据库类型 | 表名 | 字段名 |
SQL SERVER | 128个字符,临时表116个字符 | 128个字符 |
Oracle | 30个字符 | 30个字符 |
MySQL | 64个字符 | 64个字符 |
Access | 64个字符 | 64个字符 |
DB2 | 128个字符 | 128个字符
|