/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 votes370 views1 answer
Only join in sql
SQL
0 vote348 views1 answer
Update view sql
SQL
20 votes362 views1 answer
Sql change column types
SQL
0 vote335 views1 answer
Adonisjs ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote335 views1 answer
Database timezone
SQL
1 vote349 views1 answer
How to group by month using sql server
SQL
4 votes349 views1 answer
Mysql copy table with new name
SQL
5 votes411 views1 answer
Oracle drop index if exists
SQL
0 vote338 views2 answers
Laravel: customize or extend notifications - database model
SQL
0 vote341 views1 answer
Use where instead of join
SQL

Share