Explain the difference between MyISAM Static and MyISAM
Dynamic?
- 1 Answers
- 9492 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
Difference between CHAR and VARCHAR?
how to display nth highest salary from a table in a mysql query? : Mysql dba
How do I connect to mysql database?
How to drop an existing table in mysql?
Is mysql server free?
How to create and drop view in mysql?
What is a heap table?
How to dump one database for backup.
How to show table names with 'mysqlshow'?
Do I need python for mysql?
How would you enter characters as hex numbers?
What is difference between mysql and mariadb?
What is a storage engine? What are the differences between innodb and myisam engines?
Is mysql free software?
What is not null in mysql?
