3 tables But 3 files with be created namely tb_name.frm,tb

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

Question Posted / harsh

Answer Posted / harsh

3 tables

But 3 files with be created namely tb_name.frm,tb_name.myi,
tb_name.myd,

extensions of
.frm
.myi
.myd

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do I make an action query?

993

How many queries can mysql handle?

1022

How to analyze tables with 'mysqlcheck'?

1264

Can I copy mysql data directory?

969

Can you tell what are various ways to create an index?

914

What is logs in mysql?

950

How to display top 50 rows?

1114

What is 'mysqladmin' in mysql?

1074

How do I connect to mysql database?

1090

What is sharding in mysql?

1015

Can you tell which of the following where clauses is faster?

993

In mysql, what is the default storage engine?

1062

How do I edit a database in mysql workbench?

951

Does uninstalling mysql delete database?

1084

How MySQL Optimizes DISTINCT?

1165