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
- 43850 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
Why MySQL is used?
What are the two types of queries?
Why do we write stored procedures?
How many sql dml commands are supported by 'mysql'?
Can foreign key have duplicate values?
How many rows can be inserted in mysql at a time?
How to concatenate two character strings?
Write a command to view mysql database table structure?
What is a delimiter in mysql?
How do I select a table in mysql?
How to store values to array from mysql database in php?
What is difference between mysql mysqli and pdo?
What is mysql port?
How to return query output in html format?
What is blob storage?
