Bug #14661 ALTER TRIGGER trigger_name DISABLE or ALTER TABLE table_name DISABLE TRIGGERS;
Submitted: 4 Nov 2005 21:38 Modified: 4 Nov 2005 21:47
Reporter: meo bogliolo Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Stored Routines Severity:S4 (Feature request)
Version:5.0/5.1 OS:Any (ALL)
Assigned to: CPU Architecture:Any

[4 Nov 2005 21:38] meo bogliolo
Description:
Hi,

it can be useful disable triggers before massive data loading
or working with batch applications...

regards
meo

How to repeat:
The following sintax is not supported:

ALTER TRIGGER trigger_name DISABLE;
ALTER TABLE table_name DISABLE TRIGGERS;

Suggested fix:
Feature request.
[4 Jul 2009 15:41] Glen Ainscow
There doesn't appear to be a voting mechanism, so ... +1.
[9 Jul 2009 7:24] Valeriy Kravchuk
Bug #46059 was marked as a duplicate of this one.
[29 Jul 2010 16:30] Samuel Déal
+1
[2 Aug 2010 10:03] Victor Pyankov
+1
[1 Feb 2011 8:57] Ilya Kondrashov
+1
[4 Apr 2012 10:39] alek welk
+1
[19 Mar 2018 15:53] Aljosha Papsch
Yeah, this feature would be very much appreciated.