MySQL Error 1451 – ER_ROW_IS_REFERENCED_2

MySQL Error Message

Cannot delete or update a parent row: a foreign key
constraint fails (%s)

Reason for the Error

InnoDB reports this error when you try to
delete a parent row that has children, and a
foreign key
constraint fails. Delete the children first.