Hi,
I have a table with 2 fields (among others) with type timestamp ("warndate" and "date"). I run the following update: update dbowner where warndate = now(). This update affects not only on the field "warndate" but on the field "date" as well. After it the both fields got the current date and time value. I changed the name of field "date" to another and got the same result.
I got the same behavior in many mysql versions include 4.0.12.
This is how the TIMESTAMP column type works. You'll find this section of the manual to be of interest:
http://www.mysql.com/doc/en/DATETIME.html
Regards, Dmitry
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
