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

What is the full meaning of mysql?

932

How to use like conditions?

934

What is horizontally scalable?

941

What is the purpose of using a heap table?

1050

How does mysql clustering work?

865

How to extract a unit value from a date and time?

909

How do you say mysql?

847

Is postgresql better than mysql?

988

How MySQL Optimizes DISTINCT?

1064

Explain about the architecture of MYSQL?

939

What is mysql data directory? How to determine the location of the data directory?

895

How do I automate a backup in mysql?

935

What does "i_am_a_dummy flag" do in mysql?

918

Do I need to pay for mysql?

862

What is the difference between unix timestamps and mysql timestamps?

978