From: Peter Brawley
Date: April 18 2008 3:13pm
Subject: Re: History of changed rows
List-Archive: http://lists.mysql.com/mysql/212383
Message-Id: <4808BA8E.1000108@earthlink.net>
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="------------040503050505000004060506"

--------------040503050505000004060506
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

CK,

>How can we manage the history of changed rows in the database.

Point-in-time architecture. For a bit of discussion see 
http://www.artfulsoftware.com/infotree/tip.php?id=547

PB

-----

C K wrote:
> Hi all.
> How can we manage the history of changed rows in the database. I have some
> idea but not yet implemented. By using triggers to make a copy of the row
> being changed to the another table in the same db. Is there any way to only
> save the changed fields data and field name? Any other idea?
> Thanks
> CPK
>
>   
> ------------------------------------------------------------------------
>
> No virus found in this incoming message.
> Checked by AVG. 
> Version: 7.5.519 / Virus Database: 269.23.1/1385 - Release Date: 4/18/2008 9:30 AM
>   

--------------040503050505000004060506--