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

Answer Posted / ismail

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

Is This Answer Correct ?    10 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi Team, This is kartik, I recently completed my B-tech. Importance of posting this question is for to know the best books on SQL(MYSQL/Oracle)? I like SQL concept's so much, at the same time i decided to choose SQL for my career purpose. So please suggest me the best books that are very helpful for a fresher to improve concepts like (SQL/PLSQL)Basics, programming concepts, architectures etc. Please consider my request as an important one. I am very thankful to you for providing this opportunity. If possible can you please send the names of books for my personal id also: karthikgdv1206@yahoo.com. Thanks, Kartik T

1746


What is the purpose of mysql database?

485


What is mysql installer?

502


How many ways to get the current time?

510


What is text in mysql?

499






What is difference between inner vs self vs cross?

513


What is the size of mysql database?

493


What is mysql routine?

472


What is ntext?

616


How would you get the current date in mysql?

652


Does facebook still use mysql?

504


Consider you have a composite index of three columns. Now, you have to provide the value of two columns in the where clause of a select query. Do you think index can be used for the operation?

504


What are the technical features of MySQL?

583


What are the functions in mysql?

500


How to print message in mysql trigger?

1004