Posted by rob on 06/18/00 11:32

Sure, increase it in the update query, example:
UPDATE hit SET counter+1 WHERE site='www.google.com'
(assuming that counter field is integer)

John McClumpha schreef:

> Hi there - just a quick query (pardon the pun)...
>
> is there a simple (quick) way to increase the value of an integer
> field in a nominated row by 1 other than first having to retrieve the
> value and then UPDATE the appropriate field? - similar to doing a
> $Variable++ in PHP?
>
> Thanks in advance
>
> --
> John McClumpha
> Darkness Reigns - http://www.incitegraphics.com.au/darkness/

• Next in forum: select count queries
• Prev in forum: Re: increase MySQL field value by 1? (quickly/easily)
• Thread view: Re: increase MySQL field value by 1? (quickly/easily)

[Reply to this message]