Explain the difference between MyISAM Static and MyISAM
Dynamic?



Explain the difference between MyISAM Static and MyISAM Dynamic?..

Answer / amith

In MyISAM static all the fields have fixed width. The
Dynamic MyISAM table would include fields such as TEXT,
BLOB, etc. to accommodate the data types with various
lengths.

MyISAM Static would be easier to restore in case of
corruption, since even though you might lose some data, you
know exactly where to look for the beginning of the next
record.

Is This Answer Correct ?    9 Yes 1 No

Post New Answer

More MySQL Interview Questions

What is RMS Migrations

0 Answers   Steria,


how many table created when we create a table in mysql?

3 Answers  


How do I edit a stored procedure in mysql?

0 Answers  


What is a trigger in mysql?

0 Answers  


What is a tinyint?

0 Answers  






Why should I use mysql?

0 Answers  


How to concatenate two character strings?

0 Answers  


How do I download mysql?

0 Answers  


how to take mysql database backup?

0 Answers  


Explain timestamp?

0 Answers  


What is 1nf 2nf 3nf?

0 Answers  


how to repair a table in mysql?

2 Answers  


Categories