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

How to include numeric values in sql statements?

943

Explain about the architecture of MYSQL?

928

How can you take the backup and restore a mysql database using php?

906

Which statement is used in a select query for partial matching?

1138

How do I restore a database in mysql workbench?

925

What is trigger in mysql with example?

864

What is mysql shell?

906

HOW TO FIND display the total number of weeks in the year of 1998 IN EMP TABLE

2168

What do we use to remove duplicate records while fetching a data in mysql ?

913

Can varchar be primary key?

877

Is mysql free for commercial use?

849

What is ddl, dml, and dcl?

931

Is mysql from oracle?

917

Is mysql free download?

808

How to drop an existing index in mysql?

1030