/SQL/Sql reset auto increment

Sql reset auto increment

Mysql reset auto increment value

ALTER TABLE table_name AUTO_INCREMENT = 1;

16

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

Mysql reset auto increment to 1

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

1 vote315 views1 answer
Simple project for database
SQL
0 vote296 views1 answer
Selects all the columns from the sailors table
SQL
5 votes291 views1 answer
Sql first day of current year
SQL
2 votes282 views1 answer
Foreign key example in dbms
SQL
14 votes329 views1 answer
Oracle alter table add column not null
SQL
0 vote350 views1 answer
Create a plsql object
SQL
0 vote326 views1 answer
Mysql join table with a text columns with ids splited by char
SQL
-1 vote330 views1 answer
Concat two columns in sql server
SQL
0 vote308 views1 answer
Oracle sql get value from several rows and concatenate strings
SQL
3 votes341 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL

Share