A value of OFF or 0 causes triggers not to be invoked even if there may be applicable triggers. This is mostly useful for controlling recursion of triggers or for debugging triggers.

The value of TRIGGERS is passed into called procedures but other options are not.

[Tip] See Also:

SET statement.