On SQL Query editor write and execute the following code to Disable the Trigger
SET TEMPORARY OPTION FIRE_TRIGGERS = OFF;
Now do all your INSERT/UPDATE/DELETE HERE that will not fire tiggers
After your work is completed execute the following code to Enable the triggrers.
SET TEMPORARY OPTION FIRE_TRIGGERS = ON;
Et Voila
Pushparaj
No comments:
Post a Comment