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 |
What does it mean to be case sensitive?
What are the advantages and disadvantages of using mysql?
How to use sum function in where clause in mysql?
Why we use mysql workbench?
What is a mysql view?
What is row?
How does mysql encrypt passwords?
How many ways we can we find the current date using MySQL?
What is meant by decimal (5,2)?
Is mysql still relevant?
Give the syntax of Grant and Revoke commands?
What are the drivers in MySQL?
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)