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: 201

Filed under:
|
|
|

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

Related posts about mysql

Related posts about triggers