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;

Comments

Popular posts from this blog