Jim <[EMAIL PROTECTED]> writes:
>> 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.
>
>That is indeed what I ended up doing, and it worked. Thanks.
Jim,
It's good t
Brad
That is indeed what I ended up doing, and it worked. Thanks.
Jim
On Friday, March 19, 2004, at 02:07 PM, [EMAIL PROTECTED] 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 anyth
>> 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.
[EMAIL PROTECTED] 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
--
Sasha Pachev
Create online surveys at http://www.su
