RsD0p9BK
11/2/2016 - 3:59 AM

sql__increment_on_update.sql

-- how to increment integer Columns value by 1 in SQL

UPDATE myTable
SET ID = ID + 1;

-- http://stackoverflow.com/questions/9293900/how-to-increment-integer-columns-value-by-1-in-sql