ALTER TABLE table_name AUTO_INCREMENT=value;
ALTER TABLE yourTableName MODIFY yourColumnName INT NOT NULL AUTO_INCREMENT;