/SQL/Mysql auto increment after delete

Mysql auto increment after delete

Mysql reset auto increment

ALTER TABLE `Table Name` AUTO_INCREMENT = 1;

2

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

Mysql auto increment after delete

set @autoid :=0; 
update Table_Name set AutoIncremented_Column = @autoid := (@autoid+1);
alter table Table_Name Auto_Increment = 1;

@Zenonymous

0

Similar codes

0 vote202 views1 answer
Opensuse status MySQL
SQL
0 vote230 views1 answer
Sql period overlap
SQL
0 vote247 views1 answer
Oracle insert single quote in string
SQL
0 vote213 views1 answer
Postgresql conectar
SQL
8 votes262 views4 answers
Reset SQL auto increment
SQL
1 vote228 views1 answer
Plsql code for deleting a row from nested table in oracle
SQL
0 vote219 views2 answers
Drop check constraint in ms sql
SQL
0 vote221 views1 answer
Sql last 7 days
SQL
4 votes237 views1 answer
Is there any command to change postgres password
SQL
1 vote185 views1 answer
Restart identity postgresql
SQL

Share