Hello Ben,
I had the same question yesterday (but with SQLite) and there are at
least 2 solutions.
The first was already mentioned:
UPDATE table SET value = value + 1 WHERE foo = bar;
The second solution which also works is:
UPDATE table SET value = (SELECT value FROM table WHERE foo =
On Dec 29, 2009, at 3:10 AM, muzy p...@muzybot.de wrote:
Hello Ben,
I had the same question yesterday (but with SQLite) and there are at
least 2 solutions.
The first was already mentioned:
UPDATE table SET value = value + 1 WHERE foo = bar;
The second solution which also works is:
I hope this isn't a bone-head question - Is there a MySQL query that will
increment/decrement the value in an integer column with a single query - in
other words, I don't have to run a SELECT query to get the value,
add/subtract to/from the value, and then run an UPDATE query to store the
new
Ben Miller wrote:
I hope this isn't a bone-head question - Is there a MySQL query that will
increment/decrement the value in an integer column with a single query - in
other words, I don't have to run a SELECT query to get the value,
add/subtract to/from the value, and then run an UPDATE query
UPDATE SQLTABLE SET count = (count+1) WHERE PromoID=1
Is this valid for your issue? I have no way of testing or toying
On Mon, Dec 28, 2009 at 8:54 PM, Ben Miller b...@tottd.com wrote:
I hope this isn't a bone-head question - Is there a MySQL query that will
increment/decrement the value in
Ben
It seems that you can just update the column with a update query like this,
update table set field = field + 1 where some condition
This might be the thing you need.
Eric
On 12/29/09, Ben Miller b...@tottd.com wrote:
I hope this isn't a bone-head question - Is there a MySQL query
6 matches
Mail list logo