Mysql Query

[lhaynes]

I currently have a mysql(3.23.44-nt) table which stores data in the columns DateTimeIn and DateTimeOut. The data type of the two columns is timestamp (14 characters). The problem is when I run the following query (from php or mysql), "Update table SET DateTimeOut = SYSDATE()"; ,it updates both columns (DateTimeIn and DateTimeOut).

[cornelalexa]

This is because use the timestamp fields to keep track of changed records.So every update to a record will update all fields of this type at the current timedate value.

The solution is to set the both values at the same time with the valus you want.

Hope to help.
Bye.