how to increment a number field in sql code example Example: increment integer in table sql UPDATE myTable SET ID = ID + 1