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

What is mysql data directory? How to determine the location of the data directory?

717


what is mysql optimization in brief?

2121


Consider a scenario where you have to send an email to a client from the sql database. How do you think you can achieve this task?

750


How do I declare a variable in mysql?

668


What is difference between mongodb and mysql?

658


how to Return total number of rows.

728


What is an example of a delimiter?

685


How to delete a column and add a new column to database

716


Does mysql use t sql?

739


Does mysql scale well?

668


What is cast in mysql?

661


What is mysql_connect?

683


What is difference between oracle and mysql?

678


What is the difference between truncate and delete in mysql?

794


How do I change mysql password?

667