/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

9 votes302 views3 answers
Date format in sql
SQL
0 vote284 views4 answers
Convert databse to achieve log mode oracle
SQL
5 votes275 views1 answer
Sql use database
SQL
0 vote287 views1 answer
Flexible search query delete table
SQL
0 vote276 views1 answer
Mysql config slave
SQL
5 votes307 views1 answer
Mysql add user with all privileges
SQL
10 votes282 views2 answers
Show tables in schema oracle
SQL
2 votes297 views1 answer
Ifnull postgres
SQL
8 votes268 views1 answer
Insert a select statement into a table
SQL
0 vote291 views1 answer
Print boolean in plsql
SQL

Share