Re: newbie: increment an existing record

[beacker]

>> 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)