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 many ways we can get the current date in mysql?
please give me the answer for this: query which generates the second highest integer in the table?
1.how to fetch a value and Execute store procudure in mysql(INNODB) using phpMyAdmin? 2.can i wright a package in mysql database(INNODB)?
Explain MySQL locks?
What is the difference between a Table and a View?
How can you move the master database
Ondelete clause is specified with a.)Drop table b.)Delete command c.)Create table d.)Select command
What are the other commands to know the structure of table using MySQL commands except explain command?
Explain advantages of MyISAM over InnoDB?
How many services is running in sql server?
explain GROUPBY & HAVING clause with examples.
How do you start MySQL on Linux?