/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

0 vote195 views1 answer
Mysql remove bad character from all fields
SQL
5 votes179 views1 answer
Mysql created at yesterdau
SQL
1 vote187 views1 answer
Get last week data in mysql
SQL
1 vote187 views2 answers
Sql for date greater than
SQL
3 votes185 views1 answer
How to check schema privileges in oracle
SQL
0 vote197 views1 answer
Python list from sql
SQL
0 vote211 views3 answers
Call to undefined function mysql_connect()
SQL
2 votes184 views1 answer
Apex execute batch job
SQL
0 vote170 views1 answer
Json_remove mysql
SQL
2 votes177 views2 answers
How to get capital letter first in sql
SQL

Share