What is the maximum length of a table name, database name, and fieldname in My

What is the maximum length of a table name, database name,
and fieldname in MySQL?

Question Posted / pranab

Answers were Sorted based on User's Feedback

What is the maximum length of a table name, database name, and fieldname in MySQL?..

Answer / sbreddy

tablename=64
databasename=64
fieldname=64

Is This Answer Correct ?

101 Yes

12 No

What is the maximum length of a table name, database name, and fieldname in MySQL?..

Answer / virendra

Database: 64
Table: 64
Column: 64
Index: 64
Constraint: 64
Stored Function or Procedure: 64
Trigger: 64
View: 64
Compound Statement Label: 16

Is This Answer Correct ?

33 Yes

7 No

What is the maximum length of a table name, database name, and fieldname in MySQL?..

Answer / pravallika

Is This Answer Correct ?

2 Yes

0 No