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 ? My database version info is the following: mysql Ver 11.12 Distrib 3.23.32, for redhat-linux-gnu (i386) Connection id: 33216 Current database: tms_db Current user: root@localhost Current pager: stdout Using outfile: '' Server version: 3.23.32-log Protocol version: 10 Connection: Localhost via UNIX socket Client characterset: latin1 Server characterset: latin1 UNIX socket: /var/lib/mysql/mysql.sock Uptime: 89 days 8 hours 20 min 14 sec Thanks, Johan --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
