How to temporarily disable triggers in mysql 5.0?

Question

MySQL

Googled variations on a theme

SET @DISABLE_TRIGER = 1;<br/>
SET @DISABLE_TRIGERS = 1;<br/>
SET @DISABLE_TRIGGER = 1;<br/>
SET @DISABLE_TRIGGERS = 1;

However, they don't work.
Tell me - is there a solution to this problem?

Answer 1

There is no special session setting that disables triggers in mysql.
Where you googled it was suggested to write a binding in each trigger that checks the state of a regular user variable.
… IF (@DISABLE_TRIGGERS IS NULL) then…
Press +1 there and you might find it easier bugs.mysql.com/bug.php?id=14661