1. Categories >> Software >> Databases >> MySQL
  2. Suggest New Category

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

Question Posted / pranab

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 is innodb_buffer_pool_size?

0 Answers  

How to use triggers to track changes in mysql?

0 Answers  

Explain advantages of InnoDB over MyISAM?

1 Answers  

How to get a list of all tables in a database?

0 Answers  

SELECT country,city FROM customers GROUP BY country ORDER BY city DESC

5 Answers   HCL,




What is ndb in mysql?

0 Answers  

Is mysql a good database?

0 Answers  

What is a simple query?

0 Answers  

How can you add and remove any column of a table?

0 Answers  

What is clob datatype?

0 Answers  

How can a user get the current SQL version?

2 Answers  

How do I know if mysql is running on windows?

0 Answers  

For more MySQL Interview Questions Click Here
Categories