How to change a MySQL table's next autoincrement number

To change the next autoincrement ID used in a MySQL table, simply run the following command on your database:

ALTER TABLE <tablename> AUTO_INCREMENT = 99

Where <tablename> is the table you want to update, and 99 is the next number you want it to use.

  • 1 Los Usuarios han Encontrado Esto Útil
¿Fue útil la respuesta?