[ale] MySQL and changes

James Sumners james.sumners at gmail.com
Tue May 31 15:33:11 EDT 2005


Correct. Depending on the mode the server is in, MySQL will
automatically update a TIMESTAMP field and it can be manipulated with
the same functions as a DATE or DATETIME field.

On 5/31/05, Billy Passauer <hpassau at emory.edu> wrote:
> 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 ...

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



More information about the Ale mailing list