foreign key set 0
SET FOREIGN_KEY_CHECKS=0;
Source: stackoverflow.com
mysql remove foreign key constraint
ALTER TABLE jobs DROP FOREIGN KEY constraint_name
mysql disable foreign keys check
SET foreign_key_checks = 0; Code language: SQL (Structured Query Language) (sql)
Source: www.mysqltutorial.org
drop all foreign key constraints mysql
SET foreign_key_checks = 0;
Source: stackoverflow.com
drop foreign key mysql
ALTER TABLE table_name DROP FOREIGN KEY constraint_name
Source: www.tutorialspoint.com
disable foreign key constraint mysql
SET FOREIGN_KEY_CHECKS=0; TRUNCATE TABLE USERS; SET FOREIGN_KEY_CHECKS=1;