-- 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