set auto increment code example Example: how insert auto increment ALTER TABLE yourTableName MODIFY yourColumnName INT NOT NULL AUTO_INCREMENT;