/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 vote302 views1 answer
Python list from sql
SQL
0 vote288 views1 answer
How to add more columns to a table in mysql
SQL
0 vote298 views1 answer
Sql tabelle erstellen
SQL
0 vote288 views1 answer
What is the difference between now() and current_date()?
SQL
0 vote227 views1 answer
Oracle last user logon
SQL
52 votes502 views6 answers
Rename column sql
SQL
0 vote301 views1 answer
Psotgres multiple values
SQL
11 votes306 views3 answers
Sql_mode=only_full_group_by
SQL
0 vote290 views1 answer
R2dbc-postgresqldriver dependency
SQL
5 votes318 views1 answer
Get column name sql server
SQL

Share