Character limit to MYSQL field names

PlumInternet
PlumInternet used Ask the Experts™
on
Hi

We would like to know if there i a character limit to the length of the field names created in MYSQL 5.

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:


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
Guy Hengel [angelIII / a3]Billing Engineer
Most Valuable Expert 2014
Top Expert 2009
Commented:
Commented:
Yes..  64 chars... as shown in the table you have posted.

Column       64

Commented:
Sorry, as posted by tiqin44

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial