[ale] MySQL and changes

Billy Passauer hpassau at emory.edu
Tue May 31 15:21:19 EDT 2005


Christopher Fowler 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?

Might TIMESTAMP be what you're looking for?
http://dev.mysql.com/doc/mysql/en/timestamp-4-1.html

  ... Billy ...



More information about the Ale mailing list