SQL query alter table column to make column primary key and auto increment code example

Example: sql query to make a existing column auto increment

Alter table table_name modify column_name datatype(length) AUTO_INCREMENT PRIMARY KEY