[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[ale] MySQL and changes



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 ...