# 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