how to update records with foreign key constraint in mysql code example

Example: mysql remove foreign key constraint

ALTER TABLE jobs DROP FOREIGN KEY constraint_name