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