1. Categories >> Software >> Databases >> MySQL
  2. Suggest New Category

What is the difference between myisam dynamic and myisam static in mysql?

Question Posted / hemant sahu


What is the difference between myisam dynamic and myisam static in mysql?..

Answer / Karan Srivastava

MyISAM Dynamic tables have a heap file that stores data, while MyISAM Static tables store data in both a .MYD (Data) file and a .MYI (Index) file. In MyISAM Dynamic tables, the .frm file contains information about table structure including column names and types. However, in MyISAM Static tables, this information is stored in separate .MYI files.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MySQL Interview Questions

How many primary keys can be there in a table?

1 Answers  

How to returns the columns and column information pertaining to the designated table.

1 Answers  

How to check server status with 'mysqladmin'?

1 Answers  

How do you start and stop MySQL on Windows?

3 Answers  

Can we join 3 tables in mysql?

1 Answers  

Why should I use mysql?

1 Answers  

How to see the database architecture in MySQL??

3 Answers  

How to enter Characters as HEX Numbers?

1 Answers  

What is mysql_connect?

1 Answers  

How do I find users in mysql?

1 Answers  

What is select query in mysql?

1 Answers  

How do I run mysql on a mac?

1 Answers  

For more MySQL Interview Questions Click Here
Categories