List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:February 8 2002 1:56am
Subject:Re: UPDATE modifies other fields than intended
View as plain text  
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
Thread
UPDATE modifies other fields than intendedJohan van Reijendam8 Feb
  • Re: UPDATE modifies other fields than intendedPaul DuBois8 Feb