/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

34 votes283 views6 answers
Sql change data type
SQL
0 vote289 views1 answer
Could not assemble any primary key columns for mapped table sqlalchemy
SQL
-1 vote274 views3 answers
Mysql get age from date
SQL
1 vote303 views1 answer
Key validation sql
SQL
23 votes289 views4 answers
Sql server substring
SQL
11 votes305 views3 answers
Sql_mode=only_full_group_by
SQL
0 vote297 views1 answer
Sql put two columns into one
SQL
0 vote289 views1 answer
Get from database the most recent data limit by 5
SQL
1 vote296 views1 answer
Mysql event last execution
SQL
0 vote296 views1 answer
T-SQL MERGE with condition what is not matched?
SQL

Share