How to Add Auto Increment column to existing Table - MySQL Developer Tutorial

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 MariaDB Database Table.

link to scripts used in MySQL Developer Tutorial / MariaDB developer Tutorial

MySQL Tutorial for Beginners
MySQL Development Tutorial
MySQL Tutorial for developers
MySQL Development Training
MySQL training for developers
MySQL Workbench Tutorial
MySQL DBA Certification Training
MySQL DBA Tutorial Step by Step
MySQL DBA Training online free
MySQL Real Time DBA Tutorial
MySQL Administration Course step by Step
MySQL Database Tutorial
TechBrothersIT Tutorial

[WizzyWiz]

What do i do if i want to start the auto increment from number 100 for example?

[himanshusrivastav]

what to do if column already exists and I want to set it as auto_increment

[JoeStaehle]

when i did this the Values are all NULL in the id column

[sourabhyadav]

alter table pipeline add column godlvl2 int not null AUTO_INCREMENT primary key ;
error.
Incorrect syntax near the keyword 'column'.