How to SET tiggers 0 in MySQL?
- by Grijesh Chauhan
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.
