At 13:45 -0500 1/25/02, [EMAIL PROTECTED] wrote: >Hello all, > >I have a question which just may very well be ridiculous. In one table, >we have a column of type "timestamp". In normal cases, we want any changes >to this row to update this timestamp (hence the nature of this datatype). > However, there is one case where we do NOT want the timestamp to update >if we make a change to some data in that row. > >Is there any way to temporarily avoid updating a timestamp type?
Sure. Set it to its current value. UPDATE tbl_name SET ts_col = ts_col, other_col = new_value; > >Thanks for your time. > >-Ian --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php