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

यारी जदो दी फकीरा तेरे नाल लाइ आ - Most Inspirational Shabad

Feelings of Girls Related to their life

If MySql Stopped Working Unexpectedly in XAMPP Local Server