[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?
>
Yes. Just set the timestamp to itself in the UPDATE statement:
UPDATE foo SET timestampfield = timestampfield, bar = 'baz' ...etc...
http://www.mysql.com/doc/D/A/DATETIME.html
-myk
---------------------------------------------------------------------
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
