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.
Thanks,
Jim
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
[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
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
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
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 to hear that
