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]