/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

6 votes170 views1 answer
SQL insert all columns
SQL
0 vote182 views1 answer
Neo4j command to run script file
SQL
0 vote162 views1 answer
Renommer schema sql
SQL
0 vote180 views1 answer
Get last date join sql
SQL
0 vote186 views1 answer
What logs are available on RDS MySQL?
SQL
1 vote172 views1 answer
Mysql view current queries
SQL
1 vote156 views1 answer
Mysql select row with max value group by
SQL
0 vote170 views1 answer
Limit and offset in stored procedure mssql
SQL
0 vote128 views2 answers
Jupyter notebook connect to database
SQL
0 vote129 views1 answer
Sqlalchemy filter relationship
SQL

Share