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 data types in mysql?

915

Are stored procedures precompiled?

975

What does it mean to be case sensitive?

989

What is meant by decimal (5,2)?

1015

write a command to view the content of the table

895

Can mysql scale horizontally?

982

What is a tinyint?

937

How do I clear the command in mysql?

938

What is the latest mysql?

951

What can you do with mysql?

1004

What is federated tables in mysql?

903

What does mysql flush privileges do?

927

Is mysql free download?

847

How do I start mysql database?

967

What is a query in mysql?

984