/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

0 vote178 views1 answer
Grant privileges of databse to user
SQL
0 vote144 views0 answer
SQL
7 votes211 views1 answer
Mysql unsafe update
SQL
0 vote258 views1 answer
SQL Server Altering Column to be Unique
SQL
5 votes244 views3 answers
Create function in postgresql
SQL
0 vote186 views2 answers
Oracle select
SQL
0 vote140 views1 answer
Print sum of values sql
SQL
1 vote188 views1 answer
Mysql select from outside
SQL
0 vote177 views1 answer
Get last three characters in mysql column
SQL
6 votes230 views1 answer
Postgresql get year
SQL

Share