mathematical function..

[Brian Rea]

I consider myself to be new at mysql and mysql commands. I have gotten by thus far by reading and finding similar posts on the net and then putting my code together from there. I find myself needing some help now though.

I have a db with two fields that have an interger value. I need to write a sql statement that pulls the existing value, adds the value defined and then inputs the result back into the field. Is this possible and if so could someone provide me with the code to do it?

example. my fields are mnth_pts and qtr_pts and a typical value added would be 200 to each.


Thanks for your help.