Brad
That is indeed what I ended up doing, and it worked. Thanks.
Jim
On Friday, March 19, 2004, at 02:07 PM, beacker@stripped wrote:
>>> Is there a mysql command that will increment the value of a field in
>>> an
>>> existing row? I would think this would be pretty basic, but I can't
>>> seem
>>> to find anything in the online documentation.
>>
>> update t1 set f = f + 1
>
> Unfortunately that will update all the records in the database.
> It's
> likely he would prefer to update a particular record via
>
> update t1 set f = f + 1 where id = 1234;
>
> Which will update only the record matching the id of 1234.
> Brad Eacker (beacker@stripped)
>
>
