CODE EXAMPLE FOR SQL

alter table id autoincrement

ALTER TABLE allitems
MODIFY itemid INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY;