/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 vote232 views1 answer
How to delete duplicate rows in oracle
SQL
0 vote260 views1 answer
Oracle executing sqlplus commands and waiting for completion
SQL
1 vote226 views3 answers
Java.sql.sqlexception: access denied for user
SQL
3 votes227 views2 answers
Oracle apex view logs
SQL
0 vote229 views1 answer
Change redo log file size in mysql 5.6
SQL
0 vote240 views1 answer
Define a variable in mysql from select
SQL
0 vote211 views2 answers
Android sqlite query join
SQL
7 votes225 views1 answer
Return insert results in POSTGRESQL
SQL
1 vote220 views1 answer
Mysql view current queries
SQL
0 vote234 views1 answer
Soql queries for not contact related account records in salesforce
SQL

Share