Posted by Lenny on 09/28/16 11:57

On 3 Sep 2006 22:41:09 -0700, version2 wrote...
>
>Hi,
>
>i want to update each field in a database table and increment by 10.
>
>so it will look like
>
>10, 20, 30, 40, 50
>
>if anyone can help it would be great
>

If you just needed to SQL information update, maybe an SQL command similar to
this might work...

UPDATE table SET column1 = (column1 + 10);

Lenny
--
Help a community by participating in ours!
NewsGuy.Com - http://newsguy.com/charity.asp

• Next in forum: Re: Code for searching a mysql database on multiple terms inputed from an html form
• Prev in forum: Ultimate programmer's reference - Quickref.org launches
• Thread view: Re: UPDATE and increment by 10

[Reply to this message]