Search results
This tutorial shows you how to use MySQL ON DELETE CASCADE to automatically delete data from a child table when you delete data from the parent table.
For anyone using MySQL: If you head into your PHPMYADMIN webpage and navigate to the table that has the foreign key you want to update, all you have to do is click the Relational view located in the Structure tab and change the On delete select menu option to Cascade. Image shown below:
8 lut 2021 · ON DELETE CASCADE constraint is used in MySQL to delete the rows from the child table automatically, when the rows from the parent table are deleted. For example when a student registers in an online learning platform, then all the details of the student are recorded with their unique number/id.
The MySQL ON DELETE CASCADE constraint ensures that when a row in the parent table is deleted, all related rows in the child table are automatically deleted as well. This constraint helps maintain referential integrity between two tables that are connected through a foreign key relationship.
12 sty 2022 · Using ON DELETE CASCADE, all the related records in the child table get automatically deleted when the parent table data is deleted. The ON DELETE CASCADE helps you avoid writing nested queries for deleting the child table data respective to parent table data.
CASCADE: Delete or update the row from the parent table and automatically delete or update the matching rows in the child table. Both ON DELETE CASCADE and ON UPDATE CASCADE are supported.
Podsumowanie: W tym poradniku dowiesz się, jak używać MySQL ON DELETE CASCADEakcji referencji dla klucza obcego do usuwania danych z wielu powiązanych tabel. W poprzednim poradniku dowiedziałeś się, jak usunąć dane z wielu powiązanych tabel za pomocą pojedynczej instrukcji DELETE .
