/SQL/Reset auto increment in MySQL

Reset auto increment in MySQL

Mysql reset auto increment value

ALTER TABLE table_name AUTO_INCREMENT = 1;

16

Mysql reset auto increment

ALTER TABLE `Table Name` AUTO_INCREMENT = 1;

2

Reset auto increment in MySQL

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 vote297 views2 answers
Sql drop view if exists
SQL
16 votes303 views2 answers
Oracle ddl
SQL
0 vote304 views1 answer
Unique index in mysql
SQL
1 vote309 views1 answer
How to unlock table in mysql
SQL
0 vote296 views1 answer
Docker export psql sql
SQL
0 vote330 views2 answers
Create-toys-table-with-toy_name-column
SQL
13 votes301 views4 answers
Mysql access denied for user 'root'@'localhost'
SQL
0 vote350 views2 answers
How to install psql in ubuntu
SQL
18 votes305 views6 answers
Laravel form validation
SQL
0 vote315 views1 answer
Sql tablo sp
SQL

Share