Three tables 1. .frm(containg structure of table) 2. .MYI(contains Index)

How many tables will create when we create table, what are
they?

Question Posted / anand

Answer Posted / anand

Three tables
1. .frm(containg structure of table)
2. .MYI(contains Index)
3. .MYD(For containing data values)

Is This Answer Correct ?

3 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How to Change a users password from MySQL prompt. Login as root. Set the password. Update privs.

1126

Which storage engine is best in mysql?

956

Is mariadb faster than mysql?

966

List some comparisons operators used in mysql?

991

What is the difference between is null & is not null?

1000

What is mysqli_connect_error ()?

1033

What are the drivers in MySQL?

1463

How large can a mysql table be?

965

What is the use of mysql_close()?

979

Does adding an index lock a table?

963

Transactions are used to treat sets of SQL statements atomically. State Whether True or False?

1460

How does mysql encrypt passwords?

897

What's new in mysql 8?

995

Which command is used to view the content of the table in mysql?

924

What are date and time intervals?

993