General ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails December 28, 2018 Pramod T P Leave a comment Issue the queries as below SET FOREIGN_KEY_CHECKS=0; DROP TABLE TABLE_NAME; SET FOREIGN_KEY_CHECKS=1;