Saturday, September 27, 2008

Maximum length for MySQL Identifiers, database names, table names, columns, index…

Those are the maximum lenght for each MySQL identifier.

You can write names longer than the values in the table below

Identifier Maximum Length (characters)

Database 64
Table 64
Column 64
Index 64
Stored Function 64
Procedure 64
Trigger 64
View 64
Alias 255

No comments: