Database, table, index, column, and alias names are identifiers. : Introduction « Introduction « MySQL Tutorial





The maximum length for each type of identifier.

IdentifierMaximum Length (bytes)
Database64
Table64
Column64
Index64
Alias255












1.1.Introduction
1.1.1.Connecting To Your Database
1.1.2.To test whether a connection can even be made, execute the command STATUS.
1.1.3.Keywords may be entered in any lettercase.
1.1.4.You can use mysql as a simple calculator:
1.1.5.Database, table, index, column, and alias names are identifiers.