Again, assume that when you cancel a row in the person table then, you also desire to remove the rows from the employee table that is associated with the Primary key record in the person table.

Hence, we can conclude that the relation between the person and employee tables is distinct to various i.e.

An employee profile will not be existent lacking a person. However, every employee profile belongs to just one single person in the table relation.

In the MySQL database structure model, each person occupies either single or multiple employee profiles. Supposing we have created two MySQL tables person(ID, Name, Address) and Employee(EmpID, ID, Profile, Contact).In MySQL, the parent table comprises the original key values in a table whereas the child table is defined as the linked table that refers to the main key values in the parental table in a database.CASCADE: It denotes that when the parent data is affected then, the child data is also altered accordingly since it is used in aggregation to ON DELETE or ON UPDATE.ON DELETE CASCADE: This MySQL Keyword is responsible to make changes on the child table when the parent table is affected.Col1_Parent,….,ColN_Parent: These are the parent table columns which holds Primary keys to which the foreign key will be associated.ParentTable_Name: This is the name of the parent table to be used in the query statement whose primary keys are linked to being used in the child table.Col1_Child,…,ColN_Child: These are the columns of the child table which has reference to Primary key in the parental table.It has a default value as NULL when we do not provide any data type but we need to add some data type for the proper execution of query either NULL or NOT NULL. Col1.,ColN: These are the column names that we want to create with the respective data type in the table.ChildTable_Name: It denotes the name of the child table related to the parent table.A foreign key for a MySQL ON DELETE CASCADE can be generated with the help of either using MySQL CREATE TABLE or MySQL ALTER TABLE statements.Here, the terms used are explained below: REFERENCES ParentTable_Name (Col1_Parent, …., ColN_Parent) , ColNDate_Type FOREIGN KEY (Col1_Child, …, ColN_Child) We use the following syntax for the MySQL ON DELETE CASCADEfor foreign key using CREATE TABLE: CREATE TABLE ChildTable_Name(Col1 Data_Type. If you do not specify cascading deletes, the default behavior of the database server prevents you from deleting data in a table if other tables reference it.

Use the ON DELETE CASCADE option to specify whether you want rows deleted in a child table when corresponding rows are deleted in the parent table. If the ON DELETE CASCADE is defined for one FOREIGN KEY clause only, then cascading operations will throw an error. Next, we define an ON DELETE CASCADE clause for one FOREIGN KEY that must be set for the other to succeed in the cascading operations. Suppose we have created two tables with a FOREIGN KEY in a foreign key relationship, making both tables a parent and child. It is a kind of referential action related to the foreign key. ON DELETE CASCADE clause in MySQL is used to automatically remove the matching records from the child table when we delete the rows from the parent table. If your Interested to learn about the MySQL Common Table Expression(CTE)

Mysql on delete cascade