how to delete a record in mysql which has a foreign key code example

Example: mysql remove foreign key constraint

ALTER TABLE jobs DROP FOREIGN KEY constraint_name