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 is trigger in mysql with example?
What is difference between mongodb and mysql?
How do you create a primary key?
How do I view data in mysql workbench?
How many sql ddl commands are supported by 'mysql'?
Can we store pdf files in mysql?
How many groups of data types?
Is mongodb faster than mysql?
How to get the current date in mysql?
What is 'mysqlcheck'?
what is the procedure to configure the application of mysql?
What are the different mysql database engines?
Oracle (3253)
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)