Explain the difference between MyISAM Static and MyISAM
Dynamic?
Answer Posted / 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 View All Answers
Are stored procedures precompiled?
How do I start mysql from command line?
What is general log in mysql?
Can we create table in stored procedure?
What is blob in mysql?
Can you tell the difference between ereg_replace() and eregi_replace()?
How do I update a variable in mysql?
What is the difference between truncate and delete?
Where is mysql data stored?
Which storage engine is best in mysql?
What is the difference between truncate and delete in mysql?
What is datadir?
Can I use mariadb instead of mysql?
What is auto increment in mysql?
How to enter boolean values in sql statements?