How disable temporarily a foreign key constraint in MySQL?

Question

Harish

Asked: January 12, 20202020-01-12T17:29:39+00:00 2020-01-12T17:29:39+00:00In: MySQL

I have a problem with foreign key constraint in my MySQL database, it possible to disable a foreign key temporarily constraints in MySQL?

Leave an answer

Praveen · Answer 1 · 2020-01-13T04:02:58+00:00

Praveen

Set the below code before starting of database

SET FOREIGN_KEY_CHECKS=0;

and set this below code end of the database

SET FOREIGN_KEY_CHECKS=1;