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;
ALTER TABLE `customers` CHANGE `id` `id` INT(11) NOT NULL AUTO_INCREMENT;
Comments
Post a Comment
Please give your valuable feedback!