mysql delete row with foreign key constraint code example

Example: mysql remove foreign key constraint

ALTER TABLE jobs DROP FOREIGN KEY constraint_name