Ignore Foreign Key Constraints During Truncate or Drop

If you are trying to drop/delete or empty/truncate a mysql table and you keep getting an error that you are violating a foreign key constraint, you may want to temporarily ignore that constraint. The code below demonstrates how you can tell mysql to ignore foreign key checks, delete/truncate the tables you need to, then re-enable… Continue reading Ignore Foreign Key Constraints During Truncate or Drop