Re: Multiple revision of a record

2008-03-04 Thread Laurent Cerveau
Thanks to all for the answers. I have now some tries to do! Laurent Sent from my iPhone On Mar 4, 2008, at 5:58 PM, Jerry Schwartz <[EMAIL PROTECTED] infoshop.com> wrote: The tack we take is to have a separate table that tracks changes. It does, of necessity, contain the same fields as the

Re: Multiple revision of a record

2008-03-04 Thread Jerry Schwartz
The tack we take is to have a separate table that tracks changes. It does, of necessity, contain the same fields as the original record (including the ID of the records being modified). It also contains fields that specify whether the record was deleted or updated, when, and by whom. There is also

Re: Multiple revision of a record

2008-03-04 Thread Peter Brawley
Laurent, >I'd like to be able to track changes made to the attribute of one record, >without wanting to duplicate the complete record each time . How an I achieve this? It often turns out that trying to make a SQL-level audit trail of such changes is more expensive in time and code than a sim

Multiple revision of a record

2008-03-04 Thread Laurent Cerveau
Hi I am a beginner to mySQL so I hope this is not a too basic question I'd like to be able to track changes made to the attribute of one record, without wanting to duplicate the complete record each time . How an I achieve this? Thanks laurent -- MySQL General Mailing List For list archi