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 aggregate functions? Explain

1023

How can you make a database as your current database?

967

In which year mysql created?

924

How to store binary data in mysql?

965

What is unsigned in mysql?

878

How does mysql store data?

889

Can I copy mysql data directory?

877

How to use 'mysql' to run sql statements?

1031

What is 'mysqlcheck'?

973

What are date and time functions in mysql?

974

How to use regular expression in pattern match conditions?

902

Is there a free version of mysql?

894

How can we get total number of records by query in mysql?

869

What's new in mysql 8?

942

What language is used in mysql?

952