Answers were Sorted based on User's Feedback
Answer / 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
InoDB : same as BDB
|Is This Answer Correct ?||13 Yes||1 No|
Answer / sankar
its not inoDB is InnoDB
|Is This Answer Correct ?||9 Yes||1 No|
Answer / rajesh kumar
BDB supports transaction and page level locking. InnoDB
Supports Foreign Keys, Row level locking & transaction .
|Is This Answer Correct ?||3 Yes||0 No|
How to use like conditions?
How do you flush privileges?
how you will show all records not containing the name "sonia" and the phone number '9876543210' order by the phone_number field.
What is the command line end user interface - mysql?
What is sql in mysql?
What does "i_am_a_dummy flag" do in mysql?
What are the advantages of stored procedures, triggers, indexes?
Does adding an index lock a table?
What is default password for mysql?
What are the nonstandard string types?
What is delimiter $$?
How do I completely remove mysql from windows?