mysql select query with auto increment code example Example: auto_increment mysql ALTER TABLE User AUTO_INCREMENT = 1;