How to temporarily disable triggers in mysql 5.0?

Question

How to temporarily disable triggers in mysql 5.0?

13 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?

asked Mar 22, 2019 by casey | 13 views

1 Answer

pwlnw · Answer 1 · 2019-03-24T10:13:08+0000

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

How to temporarily disable triggers in mysql 5.0?

Please log in or register to add a comment.

Please log in or register to answer this question.

1 Answer

Please log in or register to add a comment.

Related questions

Most popular tags