From: Peter Brawley (peter.brawleyearthlink.net)
Date: Tue Mar 04 2008 - 09:39:26 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]