/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 vote240 views1 answer
How we can perform acid Operations in sql with examples
SQL
0 vote234 views3 answers
Sql drop all tables
SQL
0 vote259 views1 answer
Parent and child link in mysql
SQL
4 votes220 views1 answer
Psql get sequences
SQL
1 vote242 views2 answers
Sql insert timestamp
SQL
0 vote324 views1 answer
Play framework connection via windows sql server
SQL
22 votes233 views4 answers
Mysql date format
SQL
0 vote225 views1 answer
C# select Mysql
SQL
0 vote222 views1 answer
Get cpu details sql
SQL
3 votes268 views1 answer
Oracle undo tablespace schema
SQL

Share