what is the main difference between myisam and innodb

Answer Posted / manoj

both myisam and innodb are storange enginein sql.
innodb support transaction, foreign key while myisam not
support transaction.

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can a table have multiple primary keys?

487


How large can a mysql table be?

456


Explain triggers and stored procedures?

498


What are the security alerts while using mysql?

575


What is the difference between timestamp and datetime in mysql?

551






Can you tell the difference between mysql_connect and mysql_pconnect? : Mysql dba

493


How to show all records starting with the letters 'sonia' and the phone number '9876543210'

515


What is mysql server used for?

479


How do I download mysql on my laptop?

482


Consider a scenario where you have to send an email to a client from the sql database. How do you think you can achieve this task?

514


What is row level locking in mysql?

506


What are the non-standard sql commands supported by 'mysql'?

511


Is postgresql better than mysql?

513


suppose data is copie to oracle to sql by using DTS. Actully it taken 2 hours. suppose some day distribute the server in the middle of 2 hours. after how can i get the data ?

1671


How to drop an existing table in mysql?

555