MySQL ERROR 1217 (23000): Cannot delete or update a parent ROW:A foreign key constrain fails

ERROR 1217 (23000): Cannot delete or update a parent ROW:A foreign key constrain fails.

It is possible that MySQL has set the Foreign Key association in InnoDB, which makes it impossible to update or delete data. You can avoid this situation by setting the Foreign_key_checks variable.

1, set foreign_key_checks=0;

2, delete the table to delete;

3, set Foreign_key_checks=1;

MySQL ERROR 1217 (23000): Cannot delete or update a parent ROW:A foreign key constrain fails