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 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 to update automatically,
you shouldn't be using TIMESTAMP in the first place.  You probably
want DATETIME instead.

--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to