Interested to Buy Any Domain ? << Click Here >> for more details...
what are the main differences between MyISAM and InnoDB
table storage structures ?
what are the advantages and disadvantages in usage of these ?
- 10 Answers
- 44229 Views
- E2 Solutions, Tesco, I also Faced
- E-Mail Answers
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
What are the different types of triggers in mysql?
What is localhost in mysql?
How to dump a table to a file with 'mysqldump'?
How do I export mysql query results to excel?
How to insert dynamic values in mysql using php?
What is the datatype of image in mysql?
How can I create table in mysql?
Why do we use the mysql database server?
How does mysql clustering work?
How to show table names with 'mysqlshow'?
How can I change database in mysql?
What is difference between mysql mysqli and pdo?
How many primary keys can be there in a table?
What does mysql_query return?
What is processlist in mysql?
