/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

13 votes178 views3 answers
Uninstall mysql centos 7
SQL
0 vote199 views1 answer
Sql query tags
SQL
0 vote167 views7 answers
Les jointures sql server
SQL
1 vote163 views1 answer
Mysql current time
SQL
0 vote164 views1 answer
Wp_query raw sql
SQL
0 vote168 views1 answer
Postgres list tables and row counts
SQL
11 votes167 views2 answers
Mysql set safe mode off
SQL
0 vote158 views1 answer
Fetch second word from a string in ms sql
SQL
4 votes160 views2 answers
Postgres update single column
SQL
0 vote158 views1 answer
Export partttion and import in oracle
SQL

Share