/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 vote244 views2 answers
Imageview setimageresource null
SQL
0 vote244 views1 answer
Mysql root permission denied lost
SQL
24 votes226 views4 answers
How to add column sql
SQL
0 vote227 views1 answer
Sql server current time without date
SQL
2 votes236 views1 answer
Change primary key sql
SQL
2 votes245 views1 answer
Sql update from different table
SQL
-1 vote230 views1 answer
Io
SQL
8 votes229 views1 answer
Insert a select statement into a table
SQL
0 vote238 views1 answer
Oracle archivelog usage
SQL
0 vote251 views1 answer
What does leave do in mysql
SQL

Share