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

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread98905@stripped>
To unsubscribe, e-mail <mysql-unsubscribe-cyon=bestweb.net@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Thread
UPDATE modifies other fields than intendedJohan van Reijendam12 Feb
  • Re: UPDATE modifies other fields than intendedZak Greant12 Feb
Re: UPDATE modifies other fields than intendedPaul DuBois12 Feb