May 3, 2017

[HDGEM] How to temporary disable a trigger for MySQL query

Trigger 1

SET @disable_trigger = 1;
// do stuff that calls trigger 2
SET @disable_trigger = NULL;

Trigger 2

IF @disable_trigger IS NULL THEN
    // do stuff only if called from a query and not from trigger 1

Posted By Blogger to HDGEM at 5/03/2017 12:05:00 PM
Post a Comment

Featured Post


Google Tables helps you search thousands of public Fusion Tables, or millions of public tables from around the web you can import to Fusio...