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

What is mysql architecture?

766


How to give user privilages for a db. Login as root. Switch to the mysql db. Grant privs. Update privs.

668


How are mysql timestamps seen to a user?

743


What is select query in mysql?

694


How to show table structure mysql?

721


How do you know if your mysql server is alive?

748


What is clob in mysql

730


What is myisam?

724


write a command to view the content of the table

715


What is max connections in mysql?

708


How do I select a database in mysql workbench?

719


How many ways we can retrieve the date in result set of mysql using php?

748


How to store values to array from mysql database in php?

671


How many columns can a table have?

692


How do I run mysql?

713