3 tables 1.table structure(.frm) 2.table data(.myd) 3.table index(.my

how many table created when we create a table in mysql?

Question Posted / bhas

Answer Posted / bhas

3 tables

1.table structure(.frm)
2.table data(.myd)
3.table index(.myi)

Is This Answer Correct ?

5 Yes

0 No

Please Help Members By Posting Answers For Below Questions

In mysql, what is the default storage engine?

999

What are the critical issues you have resolved in your company

2230

What are the steps required to view your mysql database?

1087

What is an index? How can an index be declared in mysql?

887

Why mysql is used with php?

967

How can you make a database as your current database?

1040

Does mysql need a server?

921

Is mysql a distributed database?

962

How do I edit a trigger in mysql?

884

What is the return type of mysqli_query?

862

can you tell how can you display the maximum salary in sql? : Mysql dba

856

What is trigger in mysql with example?

910

How to returns the columns and column information pertaining to the designated table.

1017

Can we rollback truncate in mysql?

1008

What do ddl, dml, and dcl stand for?

904