E
x
c
e
l
P
T
P

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

March 4, 2014

The following table describes the maximum length for each type of identifier

IdentifierMaximum Length (bytes)
Database 64
Table 64
Column 64
Index 64
Alias 255

There are some restrictions on the characters that may appear in identifiers