Explain the difference between MyISAM Static and MyISAM
Dynamic?
Answer / 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 |
How do you rename a procedure in mysql?
How large can a mysql database become?
Difference between CHAR and VARCHAR?
How to use like conditions?
How to see the create table statement of an existing table?
Is mysql case-sensitive?
What can you do with mysql?
What is a longblob?
What are the types of index?
Is there a free version of mysql?
How do I stop a query in mysql workbench?
What are date and time data types?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)