On 27-Oct-2003 Henning Heil wrote:
> hi there,
>
> the subject tells almost everything, I try to update records in a table
> and everytime I do this, the timestamp field ist set to now().
>
> how can I keep the previously stored value for this field (there are
> values created before)?
>
UPD
Add Two Time stamps. Only one will get update.
Mat
-Original Message-
From: Keith C. Ivey [mailto:[EMAIL PROTECTED]
Sent: Monday, October 27, 2003 1:31 PM
To: MySQL List
Cc: Henning Heil
Subject: Re: updating records without changing timestamp fields
On 27 Oct 2003 at 21:21, Henning
[EMAIL PROTECTED] wrote on 27.10.2003 21:31
use timestamp_col = timestamp_col in your query, to override the NOW()
affect.
I just passed by this comment this morning
http://www.mysql.com/doc/en/DATETIME.html -- user comments at bottom of
page
hth
Jeff
all,
thanks for your help!
* Henning Heil
> the subject tells almost everything, I try to update records in a table
> and everytime I do this, the timestamp field ist set to now().
>
> how can I keep the previously stored value for this field (there are
> values created before)?
You can assign the current value to it:
use timestamp_col = timestamp_col in your query, to override the NOW()
affect.
I just passed by this comment this morning
http://www.mysql.com/doc/en/DATETIME.html -- user comments at bottom of
page
hth
Jeff
On 27 Oct 2003 at 21:21, Henning Heil wrote:
> how can I keep the previously stored value for this field (there are
> values created before)?
Explicitly SET timestamp_column = timestamp_column. See here:
http://www.mysql.com/doc/en/DATETIME.html
But if you never want the TIMESTAMP column t
That is the purpose of timestamp.
Henning Heil wrote:
hi there,
the subject tells almost everything, I try to update records in a
table and everytime I do this, the timestamp field ist set to now().
how can I keep the previously stored value for this field (there are
values created before)?