At 11:59 -0500 9/11/02, Rob Day wrote: >Hi all, >I have a table in MySQL with the following field: > 'time_date' timestamp(14) NOT NULL >When a record is inserted into the table, NULL is inserted into the >time_date field giving me a normal timestamp with the time of the INSERT. >That much is fine. >However, it is necessary for me to update some of the records in my table. >But whenever I send an UPDATE, the timestamp changes.
That is how TIMESTAMP is documented to work. > I would like for the >timestamp value to remain unchanged. Is there a way to do this without >reading the old value of the timestamp and reinserting with my UPDATE query? You don't need to read it, just set the column to itself: UPDATE tbl_name SET ts_col = ts_col, your_other_col = some_value, ... >Thanks. >-Rob > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php