What is the maximum length of a table name, a database name,
or a field name in MySQL?

Answers were Sorted based on User's Feedback



What is the maximum length of a table name, a database name, or a field name in MySQL?..

Answer / rajan vardawaj

Database name: 64 characters Table name: 64 characters
Column name: 64 characters

Is This Answer Correct ?    34 Yes 0 No

What is the maximum length of a table name, a database name, or a field name in MySQL?..

Answer / ismail

Database name: 64 characters,Table name: 64 characters,
Column name: 64 characters

Is This Answer Correct ?    10 Yes 0 No

What is the maximum length of a table name, a database name, or a field name in MySQL?..

Answer / v.srikanth

Yes

Is This Answer Correct ?    9 Yes 2 No

What is the maximum length of a table name, a database name, or a field name in MySQL?..

Answer / shripad chandratre

All has 64 characters.

Is This Answer Correct ?    6 Yes 0 No

Post New Answer

More MySQL Interview Questions

Why we use mongodb instead of mysql?

0 Answers  


What does mysql flush privileges do?

0 Answers  


What is a tinyint?

0 Answers  


What?s the difference between query_cache_type 1 and 2?

1 Answers  


What happens when the column is set to AUTO INCREMENT and you reach the maximum value for that table?

2 Answers  






How can I connect mysql database?

0 Answers  


What is difference between mysqli and pdo?

0 Answers  


What is the maximum no of columns a table can have?

0 Answers  


What is user in mysql?

0 Answers  


What are the steps involved in query processing?

0 Answers  


Why is mysql popular?

0 Answers  


What is the datatype for password in mysql?

0 Answers  


Categories