At 17:29 -0800 2/7/02, Johan van Reijendam wrote:
>Hi all,
>
>I have run into the following issue and was wondering if anyone else
>has ever run into the same and if there is an answer to this
>behaviour.
>
>I have a record which contains the following fields:
>
> id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
> create_time TIMESTAMP,
> modify_time TIMESTAMP,
> note TEXT
>
>When I update this record and modify any of the fields other than
>the 'create_time' field then the 'create_time' field gets updated as
>well. None of my calls to the database however address the
>'create_time' field.
>
>Is there some feature that I am overlooking which may be causing this ?
Yes, what you're seeing is the way the first TIMESTAMP column in a
table is supposed to behave. See:
http://www.mysql.com/doc/D/A/DATETIME.html
