Re: MySQL Increment/Decrement
| From: | Eric Lee | Date: | Tue, 29 Dec 2009 03:53:13 +0000 |
| Subject: | Re: MySQL Increment/Decrement | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-300721@lists.php.net to get a copy of this message | ||
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 <ben@tottd.com> 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 to store the
> new value?
>
>
>
> Thanks in advance.
>
>
>
> Ben
>
>