what is the difference between MyISAM and INNO DB in MySQL
with the Advantage and disadvantage

Answer Posted / tushar

MyISAM and InnoDB are storage engines in MySql.
MyISAM does not support transactions while InnoDB support
it.

Is This Answer Correct ?    27 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you kill a long running query in mysql?

638


How do I start mysql client?

700


What is ndb in mysql?

715


How many triggers are possible in mysql?

727


What is the difference between mysql_connect and mysqli_connect?

666


Consider you have the following three tables which have to be linked together.

694


How to update info already in a table and delete a row(s) from a table.

638


What are the different mysql database engines?

751


Which datatype is used for email in mysql?

702


How to escape special characters in sql statements?

711


What is data types in mysql?

654


What are the reasons for selecting lamp (linux, apache, mysql, php) instead of combination of other software programs, servers and operating systems?

778


Why do we need mysql?

710


What is ibdata1?

681


Is mysql a relational database?

599