MySql query to alter primary key to auto increment and not null
Today I am going to discuss how to alter table with primary key id as AUTO_INCREMENT and NOT NULL ALTER TABLE `customers` CHANGE `id` `id` INT ( 11 ) NOT NULL AUTO_INCREMENT ;