/SQL/Sql reset auto increment

Sql reset auto increment

Mysql reset auto increment value

ALTER TABLE table_name AUTO_INCREMENT = 1;

16

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

Mysql reset auto increment to 1

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

1 vote140 views2 answers
Drop table if exists test
SQL
13 votes115 views4 answers
Mysql select last 10 rows
SQL
2 votes163 views2 answers
Postgres drop column if exists
SQL
0 vote132 views1 answer
How to find table lock and row lock in mysql
SQL
9 votes108 views2 answers
Sql limit to 5 results
SQL
6 votes119 views1 answer
Sqlite foreign key
SQL
10 votes101 views1 answer
Oracle dependency
SQL
0 vote125 views1 answer
Postgresql function ROUND
SQL
1 vote113 views1 answer
Sql dcl
SQL
0 vote120 views1 answer
How to close external sql connection in laravel
SQL

Share