Answers for "sql add auto_increment column to existing table"

SQL
4

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
0

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 "sql add auto_increment column to existing table"

Code answers related to "SQL"

Browse Popular Code Answers by Language