Re: mysql adding
| From: | Micah Stevens | Date: | Sat, 05 Jun 2004 00:13:39 +0000 |
| Subject: | Re: mysql adding | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-34653@lists.php.net to get a copy of this message | ||
Wait, sorry, It's late..
update tablename set fieldname = fieldname + 1;
That will increment all the rows in table, you can add a 'where' statement to
limit the update.
update tablename set fieldname = fieldname + 1 where indexfield = someindex;
-Micah
On Friday 04 June 2004 01:47 pm, Steven Morgan wrote:
> is there anyway to add 1 to an int with 1 mysql query, i know i can pull
> the value down with a SELECT then add 1 with php.. then do an UPDATE on
> it.. but i didn't know if there was any other way?
> thanks
> Steve Mo'