/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 vote117 views1 answer
Sql sum if
SQL
23 votes127 views4 answers
How to show all users in mysql
SQL
0 vote134 views1 answer
MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes
SQL
1 vote166 views1 answer
Ora-01950 no privileges on tablespace
SQL
0 vote128 views1 answer
Oracle table privileges
SQL
1 vote317 views2 answers
Coderbyte sql solutions
SQL
0 vote129 views1 answer
How to import sqlite driver class in java using maven
SQL
1 vote123 views2 answers
ImportError: No module named mysql.connector
SQL
0 vote184 views1 answer
How to rename a database in tsql
SQL
18 votes118 views3 answers
Mysql number format
SQL

Share