/SQL/Reset SQL auto increment

Reset SQL auto increment

Sql server reset auto increment

DBCC CHECKIDENT (mytable, RESEED, 0)

5

Source: stackoverflow.com

Sql reset auto increment

ALTER TABLE tmp AUTO_INCREMENT = 3;

1

Reset SQL auto increment

ALTER TABLE tablename AUTO_INCREMENT = 1

1

Source: stackoverflow.com

Mysql reset auto increment id

SET  @num := 0;

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

ALTER TABLE your_table AUTO_INCREMENT =1;

1

Source: stackoverflow.com

Similar codes

0 vote129 views1 answer
Sql server convert to guid
SQL
1 vote113 views1 answer
Postgres set column equal to another
SQL
0 vote120 views2 answers
How do I UPDATE from a SELECT in SQL Server?
SQL
2 votes119 views1 answer
Oracle sql merge
SQL
94 votes141 views4 answers
Create database postgres
SQL
0 vote113 views1 answer
Mysql isshow
SQL
0 vote126 views1 answer
Insert into select with group by
SQL
0 vote120 views1 answer
Supprimer les valeur d'une table mysql
SQL
0 vote121 views1 answer
Get record which is available in one table but not in another mysql
SQL
0 vote122 views2 answers
Sql searching via key word
SQL

Share