/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

7 votes183 views1 answer
Oracle pagination query rownum
SQL
8 votes167 views1 answer
Check mysql version phpmyadmin
SQL
0 vote156 views1 answer
Mysql make date from 2 column
SQL
1 vote144 views1 answer
Ilike for date postgres
SQL
0 vote156 views1 answer
How to add more columns to a table in mysql
SQL
0 vote141 views1 answer
Minecraft duping allowed servers
SQL
0 vote160 views1 answer
Mysql insert into select with recursive
SQL
5 votes153 views1 answer
Ascending order and where in sql
SQL
0 vote199 views1 answer
Cannot start database server xampp mac os
SQL
0 vote152 views1 answer
How to check even or odd in sql
SQL

Share