MySQL: Ignore the timestamp attribute

Question

I have a timestamp column in my database, and i use it for almost every field, but now, i just want to update the hit counter.. and i do not want to update the timestamp column with it. I use the timestamp field to see the last 'content' update. Not for every hit.

Is it possible to let mysql stop updating the timestamp column for just one query?

zbateson · Accepted Answer · 2010-05-15 06:51:24Z

1

UPDATE mytable SET counter_field = counter_field + 1,
timestamp_field = timestamp_field

answered May 15, 2010 at 6:51

zbateson

1,14410 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Your Common Sense · Accepted Answer · 2010-05-15 06:45:53Z

0

That's why I never use timestamp in my web projects. As I have full control on my queries, I can always set update time manually, without relying on the unpredictable timestamp mechanism.

answered May 15, 2010 at 6:45

Your Common Sense

158k42 gold badges226 silver badges373 bronze badges

2 Comments

Nique Over a year ago

A timestamp can be handy. Less writing, except in this case.

Your Common Sense Over a year ago

@Nique I just prefer stability and predictability over less writing. Actually debugging take more tame than writing, so I'd better ease debugging part

Collectives™ on Stack Overflow

MySQL: Ignore the timestamp attribute

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related