MySQL timestamp field update problem
| From: | Rob Day | Date: | Wed, 11 Sep 2002 16:59:50 +0000 |
| Subject: | MySQL timestamp field update problem | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-21697@lists.php.net to get a copy of this message | ||
Hi all,
I have a table in MySQL with the following field:
'time_date' timestamp(14) NOT NULL
When a record is inserted into the table, NULL is inserted into the
time_date field giving me a normal timestamp with the time of the INSERT.
That much is fine.
However, it is necessary for me to update some of the records in my table.
But whenever I send an UPDATE, the timestamp changes. I would like for the
timestamp value to remain unchanged. Is there a way to do this without
reading the old value of the timestamp and reinserting with my UPDATE query?
Thanks.
-Rob