/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 vote206 views1 answer
Mysql equivalent decode oracle
SQL
8 votes208 views1 answer
How to check mysql version in xampp
SQL
0 vote194 views1 answer
Oracle get running queries
SQL
0 vote200 views1 answer
Mysql vs sql server performance benchmark
SQL
0 vote208 views1 answer
Top frequency in sql server
SQL
1 vote201 views1 answer
Add constraint sql
SQL
0 vote209 views1 answer
Sql select most frequent value in column
SQL
0 vote225 views1 answer
Oracle drop type
SQL
0 vote202 views1 answer
When mysql server would not work in xampp
SQL
0 vote205 views1 answer
C# mysql update statement set value to null
SQL

Share