Cannot delete or update a parent row: a foreign key constraint fails

Question

Hello, I get error ERROR 1217 (23000) at line : Cannot delete or update a parent row: a foreign key constraint fails

while try importing an sql

Is there any way to fix it easily?

Answer 1

You should add these lines to your sql SET FOREIGN_KEY_CHECKS=0; to the beginning and SET FOREIGN_KEY_CHECKS=1; to the end.

following this example:

SET FOREIGN_KEY_CHECKS=0;

your queries....

Drop tables....

SET FOREIGN_KEY_CHECKS=1;