2 deleted 51 characters in body
source | link

DisableIt is not possible to update the multiple tables interlinked with foreign key check off while updatingkeys. The constraints in MySQL only updates the tables and enable it once it is done

SET foreign_key_checks = 0;

your update query hererelated column.

SET foreign_key_checks = 1;

Hope this helps!

Disable the foreign key check off while updating the tables and enable it once it is done

SET foreign_key_checks = 0;

your update query here

SET foreign_key_checks = 1;

Hope this helps!

It is not possible to update the multiple tables interlinked with foreign keys. The constraints in MySQL only updates the related column.

Hope this helps!

    Post Undeleted by Vembu
    Post Deleted by Vembu
1
source | link

Disable the foreign key check off while updating the tables and enable it once it is done

SET foreign_key_checks = 0;

your update query here

SET foreign_key_checks = 1;

Hope this helps!