Re: Seriously.. When are we going to get subqueries?!

[Josh Trutwin]

On Thu, 09 Jun 2005 14:28:56 +0100
Gordan Bobic <gordan@stripped> wrote:

> My understanding was the timestamp fields were only set when the
> record  is created. They are not changed when the record is
> modified.

http://dev.mysql.com/doc/mysql/en/timestamp-4-1.html

"The first TIMESTAMP column in table row automatically is updated to
the current timestamp when the value of any other column in the row is
changed, unless the TIMESTAMP column explicitly is assigned a value
other than NULL."

Josh