Discussion board
What is the maximum length of a table name, a database name, or a field name in MySQL?
By
Hi sir,

Please tell me what is the maximum length of table name,
database name and field name in mysql
Reply
Post   Reset
Teacher SiliconIndia replied to Monday, November 23, 2009
Hi Naveen p

Maximum length for the database,table and field name is given below:

Database name: 64 characters
Table name: 64 characters
Column name: 64 characters