/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

4 votes268 views2 answers
Oracle last day of month
SQL
0 vote257 views2 answers
Sql query for getting details by id
SQL
2 votes259 views4 answers
2nd highest salary in mysql
SQL
1 vote287 views1 answer
Mysql select row max date
SQL
0 vote247 views1 answer
Permission denied postgres \copy csv command line
SQL
3 votes264 views1 answer
How to find names includes in sql
SQL
0 vote292 views1 answer
Mysql get nth highest
SQL
0 vote263 views1 answer
Oracle select partition
SQL
1 vote239 views1 answer
Select not matching data from two tables
SQL
0 vote256 views1 answer
Sql remove decimal places
SQL

Share