/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

32 votes224 views6 answers
Insert into values select
SQL
2 votes233 views1 answer
Show max_allowed_packet mysql
SQL
1 vote235 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL
0 vote218 views1 answer
Insert overwrite table in mysql in nifi
SQL
1 vote220 views1 answer
Sql server 2012 query history
SQL
0 vote279 views1 answer
ORA-32794: cannot drop a system-generated sequence
SQL
16 votes215 views1 answer
Mssql int max value
SQL
3 votes220 views2 answers
Sql paging query
SQL
6 votes177 views2 answers
Spring data jpa application.properties mysql
SQL
1 vote230 views2 answers
Snowflake alter column data type
SQL

Share