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 to print message in mysql trigger?

1523

write a command to view the content of the table

906

What is unsigned in mysql?

942

What is row?

1091

How many primary keys can be there in a table?

999

Explain Access Control Lists.

997

What is regex in mysql?

1094

What is the current mysql version?

1025

What happens when the column is set to AUTO INCREMENT and if you reach maximum value in the table?

1044

How can you filter the duplicate data while retrieving records from the table?

904

How do I connect to a database in mysql workbench?

1032

What is a transaction? Describe mysql transaction properties.

1107

1.how to fetch a value and Execute store procudure in mysql(INNODB) using phpMyAdmin? 2.can i wright a package in mysql database(INNODB)?

2517

What is text in mysql?

919

What is 1nf 2nf 3nf?

988