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

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

Question Posted / freeman

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

Please Help Members By Posting Answers For Below Questions

How do I view tables in mysql workbench?

920

What is the maximum size of mysql database?

955

What is the maximum number of records in mysql table?

920

How do I change mysql password?

1017

What is the use of count function in mysql?

1029

How does select query work?

943

How to see the create table statement of an existing table?

1050

What is index length in mysql?

942

What are date and time functions in mysql?

1014

What does the file with the extension: frm, myd, and myi contain?

924

Can you tell the difference between mysql_connect and mysql_pconnect? : Mysql dba

1028

What is a user defined variable?

915

What is normalization and list the different types of normalization?

952

What is 'mysqlcheck'?

1024

What is database engine in mysql?

937