SELECT AUTO_INCREMENT FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'dev' AND TABLE_NAME = 'employee_info'; ALTER TABLE employee_info AUTO_INCREMENT=315