[ale] MySQL and changes

[james.sumners at gmail.com (James Sumners)]

http://dev.mysql.com/doc/mysql/en/datetime.html

On 31 May 2005 15:03:52 -0400, Christopher Fowler
<cfowler at outpostsentinel.com> wrote:
> I'm running MySQL 4.X and I want to be able to see when rows are
> modified.  Is there a way to create a modified column in a table that
> gets updated with now() everytime a UPDATE or INSERT is executed?
> 
> I had a case where I needed to know when a table was changed to see if a
> data change had caused a program to act strangely.
> 
> 
> 
> _______________________________________________
> Ale mailing list
> Ale at ale.org
> http://www.ale.org/mailman/listinfo/ale
> 


-- 
James Sumners
http://james.roomfullofmirrors.com/

"All governments suffer a recurring problem: Power attracts
pathological personalities. It is not that power corrupts but that it
is magnetic to the corruptible. Such people have a tendency to become
drunk on violence, a condition to which they are quickly addicted."

Missionaria Protectiva, Text QIV (decto)
CH:D 59