/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 vote199 views1 answer
Docker open terminal mysql server
SQL
0 vote218 views1 answer
Convert LDAP Epoch to Date
SQL
0 vote202 views1 answer
Oracle winter time change
SQL
4 votes231 views2 answers
Insert current date in mysql
SQL
0 vote189 views1 answer
Postgresql delete limit
SQL
10 votes212 views6 answers
Sql between
SQL
0 vote201 views1 answer
Str_to_date sql server
SQL
0 vote190 views1 answer
Mysql update even / odd rows
SQL
2 votes189 views2 answers
Mysql bidirectional composite primary key
SQL
2 votes170 views1 answer
Codeigniter print last sql query
SQL

Share