/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 vote374 views1 answer
Mysql 8 geo to json
SQL
0 vote351 views1 answer
Fast sql column count
SQL
1 vote355 views1 answer
Query for all indexes in table postgres
SQL
17 votes351 views6 answers
Get last record in sql
SQL
0 vote398 views2 answers
Identity syntax in sql
SQL
0 vote336 views1 answer
What is the essence of SQL?
SQL
1 vote358 views2 answers
Mssql show database size
SQL
0 vote346 views1 answer
We are intrested to work with your organization
SQL
1 vote339 views3 answers
Mariadb add foreign key
SQL
0 vote362 views1 answer
PSQL use LIKE with timestamps
SQL

Share