Dropping or truncating tables with foreign key constraints in MySQL

Just a quick tip, if you need to drop a lot of tables with foreign key constraints use:

SET FOREIGN_KEY_CHECKS = 0;

CategoriesIT

Leave a Reply

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