Triggers, Table Access Restrictions, and History Tables
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..
Triiggers surrently inherit a limitation of functions in that they cannot reference other tables in MySQL.
Any idea if this is/will be supported in 5.0? Is there any mention of this issue with respect to the release roadmap?
Subject
Views
Written By
Posted
Triggers, Table Access Restrictions, and History Tables
6899
April 22, 2005 12:55AM
3522
April 24, 2005 01:21PM
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.