/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

2 votes206 views1 answer
Wait delay in sql server
SQL
4 votes220 views2 answers
Oracle unlock account
SQL
0 vote229 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
0 vote216 views1 answer
Python mysql show databases
SQL
3 votes216 views1 answer
Oracle list user grants
SQL
0 vote203 views1 answer
Redudancy in SQL
SQL
10 votes185 views2 answers
Mysql select timestamp group by day
SQL
1 vote209 views1 answer
Data type and their numeric form
SQL
2 votes212 views1 answer
SQL IF ELSE
SQL
15 votes193 views2 answers
How to drop database name in postgresql
SQL

Share