What is the Difference between InnoDB and MyISLAM Engine

A database engine (or storage engine) is the underlying software component that a database management system (DBMS) uses to create, read, update and delete (CRUD) data from a database. Most database management systems include their own application programming interface (API) that allows the user to interact with their underlying engine without going through the user interface of the DBMS. 1. Referential Integrity Referential integrity ensures that relationship between tables remains consistent and strong. Or more specifically, this means when a table has a foreign key pointing to a different table in the same database . When any update or delete

The post What is the Difference between InnoDB and MyISLAM Engine appeared first on Coding Security.

What is the Difference between InnoDB and MyISLAM Engine
read more