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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.059 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.