increase MySQL field value by 1? (quickly/easily)

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/

Re: increase MySQL field value by 1? (quickly/easily)

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/

Re: increase MySQL field value by 1? (quickly/easily)

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'

Regards
Stefan

>...

Re: increase MySQL field value by 1? (quickly/easily)

John McClumpha wrote:
> 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?

Why not use the autoincrement feature of MySql?

--
Pat