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

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

64

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More MySQL Interview Questions

What are the types of queries?

0 Answers  


How do I remove a user from mysql?

0 Answers  


How to represent ENUMs and SETs internally?

0 Answers  


How to show all tables with 'mysql'?

0 Answers  


What are the different data types in mysql?

0 Answers  


What is the usage of regular expressions in mysql?

0 Answers  


What is a session in mysql?

0 Answers  


What is int mysql?

0 Answers  


How do I grant privileges to a user in mysql phpmyadmin?

0 Answers  


What is triggers and how it can be used in mysql?

0 Answers  


What happens if null values are involved in expressions?

0 Answers  


How do you start and stop MySQL on Windows?

3 Answers  


Categories