How to Add Auto Increment column to existing Table explains how you can alter table to add auto increment to existing tables with data in MySQL Table or …
Original source
How to Add Auto Increment column to existing Table – MySQL Developer Tutorial
