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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
