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
Explain csv tables.
What is user in mysql?
What are the advantages of mysql in comparison to oracle?
How many columns can you create for an index?
How many columns can a table have?
What is a deterministic function?
What are the disadvantages of mysql?
What do you mean by % and _ in the LIKE statement?
How do I restore a database in mysql workbench?
What is general log in mysql?
How to declare variable in mysql trigger?
What is mysqli_free_result?
How to delete a database from mysql server.
How do I view tables in mysql workbench?
What are the 3 main types of search queries?