/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

9 votes132 views4 answers
How to alter table column name in mysql
SQL
2 votes129 views1 answer
Enum in SQL Server
SQL
1 vote225 views1 answer
Postgres set column based on another column
SQL
0 vote133 views1 answer
Sql server count all tables rows
SQL
0 vote157 views1 answer
000webhost database values insert
SQL
0 vote163 views1 answer
Postgresql concat string with separator
SQL
19 votes127 views2 answers
Mysql tinyint max value
SQL
0 vote145 views2 answers
Sql query print strings and int
SQL
0 vote127 views1 answer
Oracle last connection
SQL
2 votes123 views1 answer
Sql server find table name
SQL

Share