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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I create a stored procedure in mysql?

497


How can you find out the version of the installed mysql?

697


what is database black box testing? : Mysql dba

588


Does adding an index lock a table?

491


How do you create a new database in mysql?

465






Can mysql handle big data?

526


How do we use % when performing a search query?

530


write a query to mysql in safe mode and to change the root password

525


What is int unsigned?

499


table a has records 1,1,1,1 table b has records 1,1,1,1,1,1 what would be out if perform join for all cases

794


How to present a past time in hours, minutes and seconds?

551


How to upload a large file through phpmyadmin in mysql?

434


How do you rename a procedure in mysql?

454


How do I create a database in mysql workbench?

447


What are the purposes of using enum and set data types?

510