Hi!
On 2018-10-08 08:11, Hick Gunter wrote:
> 1) Include an "inserted at" timestamp column in each table
> 2) create a history table for each real table
> 3) use before triggers to copy the old record to the history table and set
> the "inserted at" timestamp
Using triggers is an interesting app
1) Include an "inserted at" timestamp column in each table
2) create a history table for each real table
3) use before triggers to copy the old record to the history table and set the
"inserted at" timestamp
If you use temp triggers, you can even keep the history tables in a separate
database fr
2 matches
Mail list logo
