/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 vote310 views1 answer
Connecting to my cloud sql server with c#
SQL
1 vote303 views3 answers
Rename table snowflake
SQL
0 vote287 views1 answer
Json_remove mysql
SQL
1 vote292 views1 answer
Create sqlite database in laravel
SQL
5 votes294 views2 answers
Mysql date greater than 30 days
SQL
0 vote306 views1 answer
Create dump file mysql workbench
SQL
5 votes311 views2 answers
Postgresql insert select
SQL
0 vote282 views1 answer
Version and edition of SQL Server Database Engine
SQL
1 vote293 views3 answers
Grant syntax in sql
SQL
0 vote326 views1 answer
How to install sql in anaconda
SQL

Share