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

5 Answers
9854 Views
I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the difference between unix timestamp and mysql timestamp?

1041

How do I show columns in mysql?

912

What is heap table?

1012

What data structure does mysql use?

977

What are the types of database engines available in mysql?

1007

What is the limit of mysql database?

941

How do you kill a long running query in mysql?

874

What is a simple query?

888

Is Mysql query is case sensitive?

1005

suppose data is copie to oracle to sql by using DTS. Actully it taken 2 hours. suppose some day distribute the server in the middle of 2 hours. after how can i get the data ?

2116

What is latest version of mysql?

990

What is pdo mysql?

909

What is difference between unix timestamp and mysql timestamp?

991

How to decrement dates by 1 in mysql?

986

What is a table schema?

976