I'm writing an invoice system in php/mysql. I need to show old invoices
exactly as they appeared at the date they were created. But I also need
to be able to update customer information. A friend of mine who's a very
knowing oracle programmer told me that in oracle it's possible to have
each update not replace old data, but automatically save a new revision.
This should make it possible to get content from a row, table possible
even entire system as it appeared on a certain date.
Is something like this possible in mysql? Any thoughts about this ...