On Thu, 09 Jun 2005 14:28:56 +0100
Gordan Bobic <[EMAIL PROTECTED]> 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

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to