MySQL Forums
Forum List  »  Triggers

No after statement trigger
Posted by: Mark Wallace
Date: November 20, 2016 03:48PM

Has anyone found a workaround for the lack of an "after statement" trigger? In my application, an "after insert for each row" won't work by itself. In Oracle, I was using "after insert for each row" to generate typically multiple new rows for each inserted row, and hold them in a temporary location. Then, the after statement trigger processed the contents of the temporary location and generated multiple inserts into the original target table, after applying some business rule logic to each one. (Note: the generated data and the trigger code were coordinated to avoid recursive firing on the generated inserts.)

It works fine in Oracle, but I don't see any way to do it with server-side computing in MySQL.

Options: ReplyQuote


Subject
Views
Written By
Posted
No after statement trigger
1739
November 20, 2016 03:48PM
658
November 20, 2016 07:38PM
845
November 20, 2016 11:17PM
668
November 20, 2016 11:39PM
790
November 20, 2016 11:56PM


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.