/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

2 votes197 views1 answer
When matched in sql server
SQL
0 vote191 views1 answer
Is numeric in sql
SQL
1 vote206 views1 answer
Oracle sequence last_number
SQL
0 vote205 views1 answer
Mariadb current date plus 1 day
SQL
0 vote208 views1 answer
Mysql join table with a text columns with ids splited by char
SQL
1 vote192 views2 answers
DROP TABLes regardless of constraints
SQL
8 votes221 views1 answer
Oracle add auto_increment column to existing table
SQL
0 vote192 views1 answer
Mysql search multiple tables
SQL
0 vote196 views1 answer
Load data from text file to mysql database on mac terminal
SQL
0 vote193 views1 answer
Monthly Birthday SQL Query
SQL

Share