/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 vote322 views1 answer
Import sql mysql ubuntu
SQL
4 votes353 views2 answers
SELECT table_name FROM user_tables;
SQL
7 votes361 views2 answers
Show size database mysql
SQL
0 vote305 views1 answer
Mysql insert with foreign key
SQL
0 vote378 views1 answer
SQL Server Enterprise
SQL
6 votes393 views3 answers
Rename column ORACLE
SQL
3 votes374 views2 answers
Postgresql remove not null constraint
SQL
0 vote335 views1 answer
Check mysql password with docker container magento 2
SQL
6 votes363 views2 answers
If not exists insert sql
SQL
0 vote352 views1 answer
Zerar auto increment mysql
SQL

Share