How can i temporarily disable key constraints in MySQL ?

See All answers

1. you can temporarily disable key constraints in MySQL by using below Global query

   This is the Query to disable foreign key constraints in MySQL

   Execute this GLOBAL query in your MySQL database

   SET GLOBAL FOREIGN_KEY_CHECKS=0;

   To revert back or Enable foreign key constraints in MySQL

   SET GLOBAL FOREIGN_KEY_CHECKS=1;

   Reply