Cacher is the code snippet organizer for pro developers

# http://www.phponwebsites.com/2014/01/mysql-add-auto-increment-to-existing-column.html

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