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|
Ondelete clause is specified with a.)Drop table b.)Delete command c.)Create table d.)Select command
Can anyone help me to create a good mysql database schema with an example. Thanks, Sekar.jr
What is the difference between mysql and sql?
What are the steps required to view your mysql database?
Which mysql function is used to concatenate string?
How many values can the SET function of MySQL take?
What is difference between group by and order by clause?
How to enter Characters as HEX Numbers?
Which statement is used to delete a table in MySQL.
how many fields can be updated using set in a mysql query?
What are the advantages of myisam over innodb?
if we want to load data from a text file into a mysql table, but the columns in table are 1st: code(int) and 2nd: city(varchar), but in text file the format is 1st cityname and then code separeted by delimeters. how to load?