/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 vote368 views1 answer
Postgresql inheritance
SQL
42 votes418 views6 answers
Install beautifulsoup
SQL
0 vote355 views1 answer
Sql get latest of 2 datetimes
SQL
3 votes335 views2 answers
Mysql create database
SQL
0 vote344 views1 answer
Formatting code with SQL Developer
SQL
1 vote325 views1 answer
Mysql connect command
SQL
1 vote347 views1 answer
How to start with sql
SQL
0 vote381 views1 answer
Insert using condition postgres
SQL
-1 vote378 views1 answer
How to reset autoincrement in sqlite java
SQL
5 votes367 views4 answers
Upload database mysql command line
SQL

Share