Three tables 1. .frm(containg structure of table) 2. .MYI(contains Index)

How many tables will create when we create table, what are
they?

Question Posted / anand

Answer Posted / anand

Three tables
1. .frm(containg structure of table)
2. .MYI(contains Index)
3. .MYD(For containing data values)

Is This Answer Correct ?

3 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How does mysql store data?

874

how to add a new column to an existing table?

935

Can you tell how to find the number of rows in a resultset using php?

859

Write a command to view mysql database table structure?

918

What is difference between unix timestamp and mysql timestamp?

942

What is difference between oracle sql and mysql?

949

How many concurrent queries can mysql handle?

853

What is mysql server used for?

886

How to filter data from a mysql database table with php?

834

Where is the myisam table stored?

898

How to return query output in xml format?

980

In mysql, what is joins? Explain

909

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

891

What is the maximum number of columns per table?

869

How to show table structure mysql?

935