Sorry,
Now I understood that this behavior is exactly according to documentation.
-----Original Message-----
Subject: mysql: bug in update (?)
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.
Regards,
Dmitry
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
