MySQL Forums
Forum List  »  Triggers

Re: After Insert Trigger
Posted by: Peter Brawley
Date: June 25, 2019 01:29PM

A point-in-time problem. SQL doesn't do time well, MySQL more so because it doesn't allow direct update insert or delete on the Trigger table, and doesn't have Instead Of Triggers.

If the history table includes full transaction state info--- problem becomes more tractable with methods described in that article. Depending on the complexity of the logic. you may need an auxiliary history-work table.

Options: ReplyQuote

Written By
June 21, 2019 10:40AM
June 21, 2019 10:54AM
June 21, 2019 11:07AM
Re: After Insert Trigger
June 25, 2019 01:29PM

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.