Updating table through arithmetic function

madlui56 · Posted: Thu Aug 30, 2007 3:07 pm

How is this done?Is this possible?
I just want to update a specific field in the table wherein I will just have to subtract an amount to that particular field..How is this done?

Such us;

Update table
set table field = (field - 400)

Thanks

dbzTHEdinosauer · Posted: Thu Aug 30, 2007 3:12 pm

yep, except for the syntax you have it right. 'Manuals' hyperlink at the very top of this page, then look for an SQL manual to find out the exact syntax for an update. You should include a WHERE clause to insure that you only UPDATE rows that you want and not all rows in the table.

The parenthesis in the SET statement are not required.

madlui56 · Posted: Thu Aug 30, 2007 3:17 pm

I will find the document you suggested

dick scherrer · Posted: Thu Aug 30, 2007 8:38 pm

Hello,

Is a negative value valid for "field"?

If not, you would test to make sure that the -400 did not result in a negative value.