Wednesday, 8 May 2013

Maximum length validation in MySQL


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

Identifier
Maximum Length (characters)
Database
64
Table
64
Column
64
Index
64
Constraint
64
Stored Procedure or Function
64
Trigger
64
View
64
Alias
256 (see exception following table)
Compound Statement Label
16

1 comment: