How to SET tiggers 0 in MySQL?
Posted
by
Grijesh Chauhan
on Stack Overflow
See other posts from Stack Overflow
or by Grijesh Chauhan
Published on 2012-11-28T05:02:19Z
Indexed on
2012/11/28
5:03 UTC
Read the original article
Hit count: 198
In my MySQL database I have some Triggers ON DELETE and ON INSERT.
Some time I need to switched-off my some Triggers, And I have to DROP e.g.
DROP TRIGGER IF EXISTS hostgroup_before_insert //
and reinstall.
Is there any shortcut to SET triggers hostgroup_before_insert = 0
like we have for foreign keys
mysql> SELECT version();
+-------------------------+
| version() |
+-------------------------+
| 5.1.61-0ubuntu0.10.10.1 |
+-------------------------+
1 row in set (0.00 sec)
- I am new learner and I could not find regarding this on web.
© Stack Overflow or respective owner
