Explain the difference between MyISAM Static and MyISAM
Dynamic?
- 1 Answers
- 9510 Views
- I also Faced
- E-Mail Answers
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 the difference between the nvl function, ifnull function, and the isnull function? : Mysql dba
What is myisam?
How to load a csv file into a table
How do I show users in mysql?
What is mysql sleep process?
What is the difference between unix timestamp and mysql timestamp?
What is flush privileges in mysql?
How do I install mysql on windows 10 64 bit?
Explain the difference between procedure and function in mysql?
Is mysql good for big data?
What is normalization and list the different types of normalization?
Is there a way to see the files which are stored?
What is the default port for mysql and how it can change?
How do I find users in mysql?
What is pdo :: fetch_assoc?
