Re: mysql adding

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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'

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux