/SQL/Mysql reset auto increment id

Mysql reset auto increment id

Mysql reset auto increment value

ALTER TABLE table_name AUTO_INCREMENT = 1;

18

Mysql reset auto increment

ALTER TABLE `Table Name` AUTO_INCREMENT = 1;

2

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

0 vote119 views1 answer
Mysql autoincrement valor inicial
SQL
0 vote134 views1 answer
Import excel to sql
SQL
39 votes193 views4 answers
Select duplicates in sql
SQL
0 vote133 views1 answer
New rails app with mysql
SQL
0 vote81 views1 answer
Sql truncate table referencing itself
SQL
20 votes136 views6 answers
Mysql reset auto increment
SQL
8 votes131 views1 answer
Declare table variable sql server
SQL
0 vote129 views1 answer
Mysql where in maintain order
SQL
11 votes133 views2 answers
Turn off safe mode mysql
SQL
0 vote131 views1 answer
Prodection ready postgres database step by step
SQL

Share