/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

1 vote178 views1 answer
Cross schema query oracle 2 users
SQL
0 vote172 views2 answers
#1273 - Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
0 vote183 views1 answer
Get rows from 1 table with other table empty mysql
SQL
0 vote174 views1 answer
Sql composite key
SQL
0 vote188 views1 answer
How to put is null in where in clause
SQL
2 votes188 views1 answer
Add default sql server
SQL
0 vote197 views2 answers
Sql server select first day of previous year
SQL
0 vote174 views1 answer
Sqlite update only if greater
SQL
0 vote190 views1 answer
How to get first 10 records of a table in mysql
SQL
0 vote169 views1 answer
LoadError: cannot load such file -- mysql2/2.7/mysql2
SQL

Share