ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails

Issue the queries as below

SET FOREIGN_KEY_CHECKS=0;

DROP TABLE TABLE_NAME;

SET FOREIGN_KEY_CHECKS=1;

Share

Leave a Reply

Your email address will not be published. Required fields are marked *