Wednesday, March 12, 2008

Calculation in an UPDATE statement

This is how you do it:
UPDATE myTable SET myField = myField + 1 WHERE myId = XXX

No comments: