alter table column auto increment code example

Example 1: mysql alter column auto increment

ALTER TABLE document MODIFY COLUMN document_id INT auto_increment

Example 2: sql query to make a existing column auto increment

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

Example 3: alter table auto_increment

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

Tags:

Sql Example

Related