Menu
I am working with mysql and have a column name with length 70.
So, I am getting error which states that the column name is too long.
Now, I just want to know what is the maximum length of column name in mysql?
934
The following table describes the maximum length for each type of identifier. Aliases for column names in CREATE VIEW statements are checked against the maximum column length of 64 characters (not the maximum alias length of 256 characters).
Each object has maximum size limitations. SQL maximum column name length limitation is 128 characters. If we create more than 128 characters, it shows an error.
Names for databases, tables, columns, and indexes can be up to 64 characters long. Alias names can be up to 256 characters long.
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 Compound Statement Label 16 Similar question is already answered Here
Anyway, Maximum allowed length of column name is 64 according to documentation : Mysql Documentation
36
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
