On Thu, 2002-02-07 at 18:29, 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 ?
Hi Johan! You are experiencing the intended behavior of that column type. Columns of the type timestamp are designed to automatically update when the rest of the column is updated. Please review http://www.mysql.com/doc/D/A/DATETIME.html -- __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Zak Greant <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Advocate /_/ /_/\_, /___/\___\_\___/ Calgary, Canada <___/ www.mysql.com 403.244.7213 --------------------------------------------------------------------- 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
