How to temporarily disable triggers in mysql 5.0?


Warning: count(): Parameter must be an array or an object that implements Countable in /home/styllloz/public_html/qa-theme/donut-theme/qa-donut-layer.php on line 274
0 like 0 dislike
12 views
Googled variations on a theme

SET @DISABLE_TRIGER = 1;
SET @DISABLE_TRIGERS = 1;
SET @DISABLE_TRIGGER = 1;
SET @DISABLE_TRIGGERS = 1;



However, they do not work.


Tell me — is there a solution to this problem?
by | 12 views

1 Answer

0 like 0 dislike
Special session settings to turn off triggers in mysql no.
Where did you Google offered in each trigger write the harness, checking the state of ordinary user-defined variable.
\r
... IF (@DISABLE_TRIGGERS IS NULL) then...
\r
Push +1 and maybe you'll feel better bugs.mysql.com/bug.php?id=14661
by

Related questions

0 like 0 dislike
2 answers
asked Jun 8, 2019 by Alk90
0 like 0 dislike
3 answers
asked Mar 22, 2019 by steff
0 like 0 dislike
2 answers
asked Mar 22, 2019 by steff
110,608 questions
257,186 answers
0 comments
27,902 users