First deactivate foreign key check. Next execute the delete statement. Don’t forget to activate foreign key check again.
Example:
SET FOREIGN_KEY_CHECKS=0; DELETE FROM user WHERE id IN (55,62); SET FOREIGN_KEY_CHECKS=1;
Knowledge should be free and accessible
First deactivate foreign key check. Next execute the delete statement. Don’t forget to activate foreign key check again.
Example:
SET FOREIGN_KEY_CHECKS=0; DELETE FROM user WHERE id IN (55,62); SET FOREIGN_KEY_CHECKS=1;