Jabbadar
7/7/2016 - 9:42 PM

Disable foreign key checks for deleting, trucating etc..

Disable foreign key checks for deleting, trucating etc..

SET FOREIGN_KEY_CHECKS=0; 
# DROP TABLE table_name; 
# TRUNCATE table_name;
# etc..
SET FOREIGN_KEY_CHECKS=1;