set auto increment constraint to an existing column in a table 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