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

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

1563

Does mysql use tcp or udp?

963

Why do you think it is advised to not to use guid and character columns as clustered index arrays?

1170

What is mysql default database?

1070

How to find the unique values if the value in the column is repeated?

1041

How do I setup mysql?

940

What is database engine in mysql?

988

How do I edit a trigger in mysql?

944

What is blob datatype in mysql?

986

How can I see mysql database?

950

Can you tell the difference between ereg_replace() and eregi_replace()?

1086

How to list or view all databases from the mysql server.

976

How do I view tables in mysql workbench?

973

Why should I use mysql?

996

Why use mysql procedures?

1025