Cascading Operations
Learn Cascading Operations (Relationships & Database Design, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.
Introduction A foreign key can declare what happens to child rows when the parent is deleted or its key changes: ON DELETE / ON UPDATE with CASCADE (apply the same change to children), SET NULL , RESTRICT or NO ACTION (block the change, the default).