Size limit for Databse Name,Table Name,Column Name, Index Name etc
Type Name |
Maximum Length (characters) |
Database |
64 (includes NDB Cluster 8.0.18 and later) |
Table |
64 (includes NDB Cluster 8.0.18 and later) |
Column |
64 |
Index |
64 |
Constraint |
64 |
Stored Program |
64 |
View |
64 |
Tablespace |
64 |
Server |
64 |
Log File Group |
64 |
Alias |
256 (some exception) |
Compound Statement Label |
16 |
User-Defined Variable |
64 |
Resource Group |
64 |
Related
find the nth highest salary in mysql without limit