From: Peter Brawley
Date: March 4 2008 3:39pm
Subject: Re: Multiple revision of a record
List-Archive: http://lists.mysql.com/mysql/211619
Message-Id: <47CD6D2E.3030100@earthlink.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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 simple implementation 
of point-in-time architecture (PITA) cf 
http://www.artfulsoftware.com/infotree/tip.php?id=530, 
http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch21.pdf).

PB

-----

Laurent Cerveau wrote:
> 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
>