All Questions in One Site: What is the maximum length of a table name, database name, and fieldname in MySQL?

What is the maximum length of a table name, database name, and fieldname in MySQL? | PHP

The following table describes the maximum length for each type of identifier.
Identifier Maximum Length
(bytes)
Database 64
Table 64
Column 64
Index 64
Alias 255
There are some restrictions on the characters that may appear in identifiers:

Pages

What is the maximum length of a table name, database name, and fieldname in MySQL? | PHP