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 you connect MySQL database with PHP?
How do I transfer data from one database to another in mysql?
What are the different data types in mysql?
What is mysql57?
How can I see all mysql databases?
How do I stop a mysql service?
What is innodb mysql?
How do I view tables in mysql workbench?
What is mysql connector used for?
What is difference between mongodb and mysql?
Can a table have multiple primary keys?
What are the differences between char and varchar?
What is prepared statement in mysql?
What is the latest mysql version?
How do you determine the location of mysql data directory?