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 mysql architecture?

1014

How to do login in mysql with unix shell.

1113

What is delimiter in mysql?

886

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

1192

Is mysql a nosql database?

1143

What is database in php mysql?

1003

Write a query to retrieve a hundred books starting from 20th.

1513

How can you export the table as an xml file in mysql?

891

What is bdb (berkeleydb)?

949

What are the column comparisons operators?

1244

How do I create a mysql username and password?

902

1)for snapshot replication which agents used? 2)for Transcation replication which agents used? 3)for merge replciation which agents used?

2008

Is mysql free software?

973

How do you create a new database in mysql?

920

What is default schema in mysql?

935