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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to get help information from the server?

548


How do I free up space in mysql?

487


Can you rename a database in mysql?

529


What is default schema in mysql?

488


What is dblink?

482






What is join in mysql? What are the different types of join?

508


Do I need python for mysql?

490


How many TRIGGERS are allowed in MySql table?

578


What is the difference between having and where clause in mysql? Explain

536


Where’s database data actually stored?

520


How do I start and stop mysql server?

472


What is insert query in mysql?

473


What are the technical specifications of mysql?

675


How to increment dates by 1 in mysql?

550


Where the database is stored in mysql?

493