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]

Reply via email to