sql query to increment a column code example Example: increment integer in table sql UPDATE myTable SET ID = ID + 1