Posted by mcyi2mr3@lycos.co.uk on 11/18/05 22:47

Hi guys

Does anyone know a quick way to add 1 to an integer value in a mysql
table collumn.

The way i use now is to extract the value from the appropriate collumn
using select then use php to create a new value ($newnumber =
$oldnumber +1) and then insert this back into my table.

Is there a faster way to do this where you can get mysql to just add +1
to whatever value is in the collumn? I have a feeling there is but my
mysql knowledge is a bit patchy.

Any help on this will be greatly appreciated.

Thanks

marc

[Back to original message]