Referential Integrity
Learn Referential Integrity (Relationships & Database Design, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.
Introduction Referential integrity means every foreign key value either is NULL or points to an existing row in the parent table. InnoDB enforces it for you on every INSERT, UPDATE and DELETE that touches a foreign key.