Answer Posted / subrat
MyISAM: This is default. Based on Indexed Sequntial Access
Method. The above SQL will create a MyISA table.
ISAM : same
HEAP : Fast data access, but will loose data if there is a
crash. Cannot have BLOB, TEXT & AUTO INCRIMENT fields
BDB : Supports Transactions using COMMIT & ROLLBACK. Slower
that others.
InoDB : same as BDB
| Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
How to get a list of indexes of an existing table?
What is mysql used for?
Is there a free mysql?
Is blocked because of many connection errors mysql?
Where is mysql data stored?
How can I see all mysql databases?
Can varchar be primary key?
what is constraints? Also explain the different types of constraints?
Why is mysql used?
What is a string in mysql?
How can you handle the –secure-file-priv in mysql?
How do I view a mysql database?
What are all the Common SQL Function?
What are Heap tables?
What are the disadvantages of stored procedures?