alter table auto increment sql table code example

Example 1: increment integer in table sql

UPDATE myTable
SET ID = ID + 1

Example 2: create table primary key auto increment mysql

define primary key auto increment