what are the main differences between MyISAM and InnoDB
table storage structures ?
what are the advantages and disadvantages in usage of these ?
Answer Posted / lekhraj deshmukh
There is foolowing Differences between MYISAM and InnoDB
ENGINE:-
1)MYISAM does not support the foreign key constraint and
transaction but InnoDB support it.
2)MYISAM is faster then the InnoDB but in case of perforing
the count operation it takes more time then the InnoDB.
3) MYISAM occupies less memory sapce for tables rather than
InnoDB tables.
Is This Answer Correct ? | 79 Yes | 5 No |
Post New Answer View All Answers
How do I find the database name in mysql?
How can you export the table as an xml file in mysql?
How can an index be declared in mysql?
What does the file with the extension: frm, myd, and myi contain?
Why is it called mysql?
What is RMS Migrations
What are string data types?
Where is the mysql data directory?
How to calculate expressions with sql statements?
how to take mysql database backup?
What is a deterministic function?
Which is best pdo or mysqli?
How can you change the password of a mysql user?
How you will Show unique records.
How to represent ENUMs and SETs internally?