MySQL modified Alter a column to be AUTO INCREMENT

Description

Mysql modified Alter a column to be AUTO INCREMENT

add primary key auto_increment mysql. AUTO INCREMENT modified 

and edit table after make table and existing table

Insert auto increment primary key to existing table 

mysql Add Auto-Increment ID to existing table

when we are create table and then now my requirement is modified

and edit AUTO INCREMENT id in mysql

 

Note May be this query not run duplicate id or modified same id

 

auto increment Mysql query

 

ALTER TABLE maintimetableadd CHANGE id id INT(10)AUTO_INCREMENT PRIMARY KEY;