/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

3 votes296 views1 answer
Index using in query plsql
SQL
1 vote311 views2 answers
Rebuild index sql server
SQL
0 vote326 views1 answer
How to create a table based on another table in mysql
SQL
0 vote310 views1 answer
Add column to table with default value plsql
SQL
1 vote399 views2 answers
Begin transaction sql
SQL
1 vote312 views1 answer
How to find median of a column sql
SQL
0 vote377 views1 answer
Add two days to current date in sql when creating tables
SQL
0 vote312 views1 answer
Sql offfset
SQL
0 vote305 views1 answer
Sql select all tables from database change url
SQL
10 votes310 views1 answer
Query to find object dependencies in oracle
SQL

Share