MySQL Forums
Forum List  »  Triggers

how to do a rollback in trigger for AFTER insert
Posted by: Samir Seba
Date: October 21, 2005 07:10AM

Hi,

suppose i have a trrigger for after insert , and in my trigger body i did some checks
and notice tht i have to rollback the insert .
how can i do a rollback.

and even in trigger before insert , how can i tell to mysql don't do the insert.

Options: ReplyQuote


Subject
Views
Written By
Posted
how to do a rollback in trigger for AFTER insert
3899
October 21, 2005 07:10AM


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.