MYSQL:Set AUTO_INCREMENT attribute to the field name

We can change the field attribute by using ALTER AND CHANGE keywords.
Ex:

ALTER TABLE table_name CHANGE old_feild new_field datatype AUTO_INCREMENT;