MySQL Forums
Forum List  »  Stored Procedures

Re: Development of touching tables in functions
Posted by: Eric Raymond
Date: April 22, 2005 12:52AM

I'd like to be able to maintain history tables via triggers. That is, when an insert or update is made to table foo, a copy of that row (more/less) is added to a table called foo_hist..

We currently enforce this via application level code that does and insert/select but havbing this done at the app level is not ideal.

Any idea if this is/will be supported in 5.0? Is there any mention of this issue with respect to the release roadmap?

Options: ReplyQuote




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.