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--- http://www.artfulsoftware.com/infotree/Transaction%20time%20validity%20in%20MySQL.pdf---the 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


Subject
Views
Written By
Posted
1120
June 21, 2019 10:40AM
540
June 21, 2019 10:54AM
548
June 21, 2019 11:07AM
Re: After Insert Trigger
528
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.