Answers for "alter table column to auto increment"

sql query to make a existing column auto increment

Alter table table_name modify column_name datatype(length) AUTO_INCREMENT PRIMARY KEY

Posted by: Guest on October-28-2020

alter table auto_increment

ALTER TABLE ALLITEMS CHANGE itemid itemid INT(10)AUTO_INCREMENT PRIMARY KEY;

Posted by: Guest on August-28-2020

Code answers related to "alter table column to auto increment"