/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

4 votes206 views4 answers
Mysql get date from datetime
SQL
9 votes196 views5 answers
Laravel to sql
SQL
0 vote171 views1 answer
Psql select * from table
SQL
0 vote172 views1 answer
Downgrading sql localdb visual studio
SQL
-1 vote219 views1 answer
How to Activate the database
SQL
3 votes255 views1 answer
How to get yesterday date in sql
SQL
0 vote201 views1 answer
Mysql date without time
SQL
38 votes259 views4 answers
Count sql
SQL
0 vote177 views1 answer
Mysql record group by created date count
SQL
0 vote171 views1 answer
Restart sql server command line linux
SQL

Share