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 can you make a database as your current database?

953

When to use order by in delete statement?

976

Why we use mysqli instead of mysql?

1007

What are enums used for in mysql?

948

What is a transaction? Describe mysql transaction properties.

1035

What is mysql optimization?

857

Write a query to stop mysql in unix

994

Tell us something about heap tables?

937

How to convert character strings to dates?

1028

What is innodb_buffer_pool_size?

912

How to drop an existing view in mysql?

881

How many columns can a table have?

852

How to return query output in xml format?

981

What are the disadvantages of mysql?

1006

How large can a mysql database become?

917