/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 vote305 views1 answer
Sqlite closes value
SQL
0 vote307 views1 answer
Sql create table with references not primary key
SQL
6 votes324 views2 answers
If not exists insert sql
SQL
0 vote308 views1 answer
Soql user profile
SQL
0 vote308 views1 answer
Export partttion and import in oracle
SQL
0 vote292 views1 answer
Clone table structure mysql
SQL
0 vote333 views1 answer
How to find total working hour in sql
SQL
0 vote354 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL
0 vote317 views1 answer
Install sql server in ubuntu 20.04
SQL
1 vote328 views1 answer
Oracle previous year
SQL

Share