(Re)Creating an auto incremented column using alter table in MySQL

The column must become a key column. ```sql alter table my_table add id int primary key auto_increment; ```