sql reset auto increment
snippet in sql

mysql reset auto increment value

user6659

ALTER TABLE table_name AUTO_INCREMENT = 1;

mysql reset auto increment id

user1329

SET  @num := 0;

UPDATE your_table SET id = @num := (@num+1);

ALTER TABLE your_table AUTO_INCREMENT =1;

sql reset auto increment

user8658

ALTER TABLE tmp AUTO_INCREMENT = 3;

mysql reset auto increment to 1

user4147

ALTER TABLE tablename AUTO_INCREMENT = 1

sql server reset auto increment

user2949

DBCC CHECKIDENT (mytable, RESEED, 0)