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
Where is mysql data stored linux?
Transactions are used to treat sets of SQL statements atomically. State Whether True or False?
What language is used in mysql?
How do you backup a database in mysql?
What are the types of queries?
What is the use of mysqli_num_rows?
Write command to import an mysql file?
How to get the number of rows selected or affected by a sql statement?
What is cast in mysql?
What is mysql data directory? How to determine the location of the data directory?
What is the data type for file in mysql?
What are federated tables?
What is difference between mysql mysqli and pdo?
How do I disable mysql?
In mysql, what is the default storage engine?