how many table created when we create a table in mysql?

Answer Posted / bhas

3 tables

1.table structure(.frm)
2.table data(.myd)
3.table index(.myi)

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Do I need to pay for mysql?

496


What is the maximum number of records in mysql table?

458


What is a trigger in mysql?

553


Can mongodb replace mysql?

529


Can you tell a way to know the number of days between the two given dates in php?

590






Which is faster innodb or myisam?

514


What does tinyint mean?

519


What is data directory in mysql?

485


How do I set user privileges in mysql?

483


How can you retrieve a particular number of records from a table?

503


Can python connect to mysql?

486


What is the storage engine for mysql?

500


What are the types of queries?

496


How to validate email addresses in mysql?

603


How do I view a mysql database?

483