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
What is mysql database server?
Is null in mysql?
Is mysql case-sensitive?
Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?
Does adding an index lock a table?
Consider you have a composite index of three columns. Now, you have to provide the value of two columns in the where clause of a select query. Do you think index can be used for the operation?
What is a definer?
What is a csv table?
What is max connection in mysql?
How do I edit a table in mysql workbench?
How do I edit a stored procedure in mysql?
What are the technical features of MySQL?
What is ndb in mysql?
Explain triggers and stored procedures?
explain GROUPBY & HAVING clause with examples.