Error Mysql when you try to delete row - Cannot delete or update a parent row: a foreign key constraint fails

cannot_delete_or_update_parent_row.md

Error Mysql when you try to delete row - Cannot delete or update a parent row: a foreign key constraint fails

You can't delete this row because any other is link to her with a foreign key

Find errors

1. Try to delete
2. View log with SHOW ENGINE INNODB STATUS;

Force delete row

1. Disable foreign key SET FOREIGN_KEY_CHECKS=0;
2. Delete row
3. Enable foreign key SET FOREIGN_KEY_CHECKS=1;