/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

7 votes140 views2 answers
3rd height salary sql
SQL
11 votes212 views2 answers
Sql between date range
SQL
-1 vote125 views1 answer
Sql getdate date only
SQL
0 vote126 views1 answer
Check duplicate values plsql
SQL
7 votes102 views1 answer
Alter table add key sql
SQL
10 votes144 views1 answer
Oracle dependencies table
SQL
4 votes127 views2 answers
Sql table
SQL
0 vote130 views1 answer
Wp_query raw sql
SQL
2 votes132 views1 answer
Oracle sql drop column if exists
SQL
12 votes131 views2 answers
Select into insert sql server
SQL

Share