MySQL Forums
Forum List  »  Triggers

is it possible to create multiple trigger_event in one trigger
Posted by: Sultana Jahan Rini
Date: March 01, 2006 11:48PM

Dear all,

Is it possible in mysql to create a trigger which can be fire both for insert or update on a certain table.

The trigger is as below:

DELIMITER '//';

CREATE TRIGGER trig_insert_route_sample
BEFORE INSERT OR UPDATE ON route
FOR EACH ROW

BEGIN
...........

END;
//
DELIMITER ';'//

Options: ReplyQuote


Subject
Views
Written By
Posted
is it possible to create multiple trigger_event in one trigger
2967
March 01, 2006 11:48PM


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.