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]