/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 vote128 views1 answer
Mysql where in keep order
SQL
2 votes176 views2 answers
Postgres drop column if exists
SQL
4 votes121 views1 answer
Mysql insert from local csv
SQL
0 vote130 views2 answers
How to find sql server agent jobs related to a database
SQL
1 vote143 views1 answer
How to put value in variable mysql
SQL
0 vote137 views3 answers
Duplicate row mysql
SQL
7 votes143 views4 answers
Database dump mysql command
SQL
0 vote120 views1 answer
Convert rows to columns in sql server
SQL
0 vote141 views1 answer
Sql convert float to string
SQL
0 vote132 views1 answer
How much table store postgres
SQL

Share