Database: 64 Table: 64 Column: 64 Index: 64 Constraint: 64 Stored

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

Question Posted / virendra

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

What is ISAM?

696

How do I change the max connections in mysql?

469

How do you rename a procedure in mysql?

454

What is difference mysql and mysqli?

515

How to create a test table in your mysql server?

503

What is different between sql and mysql?

508

Write a query to display even rows in student table using mysql?

489

What is maximum table size in mysql?

486

What is view? How can you create and drop view in mysql?

486

Can python connect to mysql?

486

Restore database (or database table) from backup.

561

How do I completely remove mysql from windows?

454

How can I change database in mysql?

454

Can you tell few best practices to be followed for optimization in sql?

506

Does uninstalling mysql delete database?

496