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

What are the functions of commit and rollback statements?

550


What is blob and text in mysql?

606


What is regexp?

650


What does mysqli_fetch_assoc do?

483


can you tell how can you display the maximum salary in sql? : Mysql dba

462






How do I fix a crashed mysql database?

489


what is cte? : Mysql dba

512


What is latest version of mysql?

499


How to insert html code into mysql database using php?

530


Does mysql scale well?

497


In how many ways we can retrieve the data in the result set of MySQL using PHP? What is the difference between mysql_fetch_object and mysql_fetch_array ?

527


How to shut down the server with 'mysqladmin'?

537


Write a query to select all teams that won either 1, 3, 5 or 7 games.

809


What is mysqlcheck do?

530


How to get a version of mysql?

528