[ale] MySQL and changes

Christopher Fowler cfowler at outpostsentinel.com
Tue May 31 15:25:50 EDT 2005


I'm using datetime throughout the whole application.  I was looking for
a way that MySQL would update the time even if I went into the db via
the command line client and did an update. Like an audit.


On Tue, 2005-05-31 at 15:11, James Sumners wrote:
> 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
> > 
> 



More information about the Ale mailing list