How to start Auto increment mysql int column at 10000 or any number?

0 Vote Up Vote Down

Try below SQL query for Autoincrement MySQL int column at 10000 or any Number

For star at 10000-
ALTER TABLE table_name AUTO_INCREMENT = 10000;

For start any number-
ALTER TABLE table_name AUTO_INCREMENT = 20;

mysql Auto increment mysql Auto increment start at any number