Enable or Disbale Triggers in MySql

In MySql, you can be enable/disable triggers whenever you want. Just simply follows below guidelines.

Step 1

write the below these lines instead of "begin" in trigger before sql statement every time when you will create the trigger.

thisTrigger: BEGIN

IF ((@TRIGGER_CHECKS = FALSE) OR (@TRIGGER_BEFORE_INSERT_CHECKS = FALSE)) AND (USER() = 'username@host') THEN

    LEAVE thisTrigger;

END IF;

username such as root, username(if you are created user)

host such as localhost, ip of server, etc.

Step 2

 Whenever you want the enable or disable triggers then use below query in MySql.

1. If you want disable all Before Insert triggers.

SET @TRIGGER_BEFORE_INSERT_CHECKS = FALSE;

2. If you want disable all After Insert triggers.

SET @TRIGGER_AFTER_INSERT_CHECKS = FALSE;

3. If you want disable all Before Update triggers.

SET @TRIGGER_BEFORE_UPDATE_CHECKS = FALSE;

4. If you want disable all After Update triggers.

SET @TRIGGER_AFTER_UPDATE_CHECKS = FALSE;

5. If you want disable all Before Delete triggers.

 SET @TRIGGER_BEFORE_DELETE_CHECKS = FALSE;

6. If you want disable all After Delete triggers.

 SET @TRIGGER_AFTER_DELETE_CHECKS = FALSE;

7. If you want disable all triggers.

SET @TRIGGER_CHECKS = FALSE;

If you want enable triggers just pass "TRUE" in query.

Cheers!!!