MySQL Forums
Forum List  »  Triggers

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
Re: How to disable all database triggers??? Thanks
25304
December 08, 2006 09:35AM


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.