Re: Avoiding the update of a timestamp in MySQL
| From: | DL Neil | Date: | Wed, 13 Mar 2002 22:59:55 +0000 |
| Subject: | Re: Avoiding the update of a timestamp in MySQL | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-17660@lists.php.net to get a copy of this message | ||
Hi Andy,
> I have a timestamp in my table to store a date. Now I have to update
other
> columns and everytime I do this, the timestamp is updated as well. Is
there
> a other way then getting the value infront and storing it again?
If you have first read the row's data, UPDATE the timestamp field with
the same/read data, then MySQL won't insert NOW() instead.
Regards,
=dn
PS did you get an answer to your CA->Canada question?