We've got about 1,000 records in a table that have timestamps on them. We've ran into a situation where we need to go back and update one field in all of those records without altering the timestamp. since the timestamp is automatically changed when the record is updated we are in a bind.
The sql we need to run is "UPDATE `table` SET `AID` = 2 WHERE `SID` = 5" Is there a way to do this sort of update but tell mysql to leave the timestamps alone? Maybe by copying the table to backup and then back again (only I can't figure out the sql to do that)? Thanks for any and all help. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]