turn foreign key constraint off mysql code example

Example 1: mysql remove foreign key constraint

ALTER TABLE jobs DROP FOREIGN KEY constraint_name

Example 2: turn on foreign keys check mysql

SET FOREIGN_KEY_CHECKS=0;