/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 vote284 views1 answer
Mysql read row
SQL
0 vote289 views1 answer
Load data from text file to mysql database on mac terminal
SQL
0 vote289 views1 answer
Join creating duplicate columns sqllite
SQL
1 vote291 views1 answer
Ubuntu access database from terminal
SQL
3 votes296 views2 answers
Postgres show table schema
SQL
0 vote286 views2 answers
Sql query in dax power bi
SQL
2 votes313 views1 answer
Oracle insert or update
SQL
0 vote271 views1 answer
Mql5 list all available symbols
SQL
4 votes284 views1 answer
Sql delete where in select
SQL
0 vote302 views1 answer
Oracle list partitions
SQL

Share