/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

1 vote197 views1 answer
T-SQL / AZURE Reseed
SQL
0 vote181 views1 answer
Add sqlite3 in lumen
SQL
0 vote178 views1 answer
Add plugins to mysql workbench
SQL
0 vote182 views3 answers
Mysql delete if not in another table
SQL
15 votes229 views5 answers
Show tables in oracle
SQL
26 votes180 views2 answers
What is the sql statement that finds duplicate usernames
SQL
1 vote124 views1 answer
Mysqldump: couldn't execute 'select column_name,
SQL
20 votes185 views3 answers
Update values in select statement sql
SQL
1 vote192 views1 answer
Liquibase alter column type / length
SQL
1 vote200 views1 answer
Mysql select if empty result
SQL

Share