1.InnoDB: InnoDB works on relational database way.
example: if you create two tables and create a relation first table to second table like first table has a primary key and second table has a foreign key, now if anyone wants to delete first table row then mysql will throw an error, as mysql won't accept this type of deletion.
1. MyISAM: MyISAM does not care about relational way.
example: in MyISAM you can delete the primary row/ parent data. in this way mysql will accept it.
----------------------------------------------------------------------------------------------------------
2. InnoDB: InnoDB works in row block way.
2. MyISAM: MyISAM works in table block way.
----------------------------------------------------------------------------------------------------------
3. InnoDB is good for write operation[insert, update, delete].
3. MyISAM is faster in read operation[fetching data].
example: if you create two tables and create a relation first table to second table like first table has a primary key and second table has a foreign key, now if anyone wants to delete first table row then mysql will throw an error, as mysql won't accept this type of deletion.
1. MyISAM: MyISAM does not care about relational way.
example: in MyISAM you can delete the primary row/ parent data. in this way mysql will accept it.
----------------------------------------------------------------------------------------------------------
2. InnoDB: InnoDB works in row block way.
2. MyISAM: MyISAM works in table block way.
----------------------------------------------------------------------------------------------------------
3. InnoDB is good for write operation[insert, update, delete].
3. MyISAM is faster in read operation[fetching data].
No comments:
Post a Comment