how to turn off foreign key constraint in mysql code example

Example: mysql remove foreign key constraint

ALTER TABLE jobs DROP FOREIGN KEY constraint_name