I have the timestamp column in my database, and I use it for almost every field, but now, I just I want to update hit counters .. and I do not want to update timestamp columns with it. I use the timestamp field to see the last 'content' update, not for every hit.
Is it possible that MySQL simply updates timestamp columns for one query?
update mytable SET counter_field = counter_field + 1, timestamp_field = timestamp_field
Comments
Post a Comment