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

What is 'mysqlcheck'?

802

How do I copy a table in mysql?

724

Explain csv tables.

746

Is mysql a server?

664

What are the 'mysql' command line options?

730

What is not null in mysql?

756

What is the difference between truncate and delete?

832

Explain the storage engines in mysql?

796

What is foreign key in mysql?

813

What is the difference between now() and current_date()?

748

How do you insert a table?

697

How many queries can mysql handle?

758

Do while loop in mysql procedure?

844

What are features of mysql?

688

How to use sum function in where clause in mysql?

729