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 Henning Heil <[EMAIL PROTECTED] To: MySQL List <[EMAIL PROTECTED]> com> cc: Subject: updating records without changing timestamp fields 10/27/2003 03:21 PM 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)? thanks for your help, henning -- 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]