Posted by NC on 11/18/05 22:59

mcyi2mr3@lycos.co.uk wrote:
>
> Is there a faster way to do this where you can get mysql to just add +1
> to whatever value is in the collumn?

Yes:

UPDATE the_table SET the_field=the_field + 1 WHERE [condition]

Cheers,
NC

• Next in forum: Is this possible ??
• Prev in forum: quick way to add 1 to an integer value in a mysql table
• Thread view: Re: quick way to add 1 to an integer value in a mysql table

[Reply to this message]