SolutionCottage.com
Posted  12 Jan 2009 - 14:51:51

Category: SQL


Increment field in SQL

Issue:
You might want to increment an existing value in an SQL field. You might even go about doing this by using an operator such as += or -=.

Solution:
The easiest way of incrementing a field is the following:

UPDATE tableName SET valuefield = valuefield + 10








0 comments:








© SolutionCottage 2008-2011 9/26/2017 10:02:00 AM