Posted by Etienne Marais on 11/22/05 08:59

Gordon Burditt 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?
>
> Autoincrement doesn't increment a field in an existing row.
> It assigns a value to a field in a *NEW* row being inserted.

Furthermore, you can use auto_increment only on (primary?) key fields.

--
Etienne Marais
Cosmic Link
South Africa

[Back to original message]