/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

3 votes366 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL
2 votes365 views6 answers
Mysql change timezone
SQL
4 votes361 views1 answer
Data types in sql
SQL
1 vote328 views1 answer
Mysql random limit 1
SQL
2 votes322 views2 answers
Install sqlalchemy
SQL
6 votes362 views2 answers
Difference between join vs union
SQL
0 vote344 views1 answer
Leftjoin in sql
SQL
4 votes339 views1 answer
SQL find text in SP
SQL
0 vote341 views1 answer
Sql show all users
SQL
4 votes329 views2 answers
Mysql select where starts with
SQL

Share