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

Question Posted / shahid

Answers were Sorted based on User's Feedback

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

Answer / freeman

If you create one table , then only one table with be created.

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

Is This Answer Correct ?

26 Yes

0 No

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

Answer / bhas

dear chandu
.frm->from mysql
.myi->mysql index
.myd->mysql data

Is This Answer Correct ?

7 Yes

0 No

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

Hi Freeman ,
Can u please let me know the extensions of
.frm
.myi
.myd

Thanks in advance
Chandu

Is This Answer Correct ?

4 Yes

1 No

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

Answer / 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

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

Answer / chandresh modi

3 tables

Is This Answer Correct ?

2 Yes

6 No