Page 1 of 1

How do I add 1 number to the db?

Posted: Tue Mar 09, 2004 9:30 am
by Wuggy
example:
The number in the database is 4, the script adds 1 to the table and it becomes 5

Sounds like a newbie question, but I can't find any tutorials or help on it :-\.

Posted: Tue Mar 09, 2004 9:43 am
by markl999
UPDATE tablename SET colname=colname+1 WHERE something='whatever'

thanks much

Posted: Tue Mar 09, 2004 11:22 am
by Wuggy
:D