backward increment in sql code example
Example 1: sql query to make a existing column auto increment
Alter table table_name modify column_name datatype(length) AUTO_INCREMENT PRIMARY KEY
Example 2: increment integer in table sql
UPDATE myTable
SET ID = ID + 1