Re: Avoiding the update of a timestamp in MySQL
| From: | andy | Date: | Thu, 14 Mar 2002 11:57:06 +0000 |
| Subject: | Re: Avoiding the update of a timestamp in MySQL | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-17682@lists.php.net to get a copy of this message | ||
Hi,
thanx I try that.
andy
PS: yes I did, but did not try it yet. Thanx
"Dl Neil" <PHPml@DandE.HomeChoice.co.uk> schrieb im Newsbeitrag
news:0c8601c1cae2$d26b6dc0$c200a8c0@jrbrown...
> 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?
>