Pages

Oct 3, 2018

[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
END IF;


--
Posted By Blogger to HDGEM at 5/03/2017 12:05:00 PM

QuickBooks Self-Employed

Bigger tax refunds. Better organization. Manage your deductions with QuickBooks Self-Employed .