Skip navigation links

MySQL Forums :: Triggers :: How to disable all database triggers??? Thanks


Advanced Search

Re: How to disable all database triggers??? Thanks
Posted by: Radu Virgil ()
Date: December 08, 2006 09:35AM

Add a condition in your triggers like:

if (DISABLE_TRIGER <> 1 ) then
#trigger body
end if;

and than if you want to disable triggers on import just:

SET @DISABLE_TRIGER = 1;

do imports

SET @DISABLE_TRIGER = 0;



Edited 1 time(s). Last edit at 12/08/2006 09:37AM by Radu Virgil.

Options: ReplyQuote


Subject Views Written By Posted
How to disable all database triggers??? Thanks 8249 Ezequiel Gallo 10/26/2006 12:45PM
Re: How to disable all database triggers??? Thanks 5993 William Chiquito 10/26/2006 04:14PM
Re: How to disable all database triggers??? Thanks 23582 Radu Virgil 12/08/2006 09:35AM
Re: How to disable all database triggers??? Thanks 9003 Utkal Ranjan 01/03/2007 04:17AM
Re: How to disable all database triggers??? Thanks 9026 Jonathan Stephens 01/09/2007 07:36PM
Re: How to disable all database triggers??? Thanks 7570 Nicolae Namolovan 12/01/2007 05:28AM
Re: How to disable all database triggers??? Thanks 5560 MARK ROBSON 05/08/2009 06:55AM
Re: How to disable all database triggers??? Thanks 7847 George Charalampidis 12/18/2008 05:13AM


Sorry, you can't reply to this topic. It has been closed.

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.