Reply to Re: increase MySQL field value by 1? (quickly/easily)
Posted by Stefan Rybacki on 09/29/68 11:32
rob@centralpoint.nl wrote:
> Sure, increase it in the update query, example:
> UPDATE hit SET counter+1 WHERE site='www.google.com'
> (assuming that counter field is integer)
Well, should be:
UPDATE hit SET counter=counter+1 WHERE site='www.google.com'