/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

2 votes358 views1 answer
How to find table table in stored procedure sql server
SQL
0 vote347 views1 answer
SQL query to verify the size of the table
SQL
8 votes319 views1 answer
Oracle add month
SQL
0 vote352 views1 answer
Add timestamp column to existing table t-sql
SQL
1 vote344 views1 answer
Expression number 1 of select list is not in group by clause
SQL
5 votes342 views3 answers
Bash: mysql: command not found
SQL
0 vote313 views1 answer
Changer un mot de passe mysql
SQL
0 vote328 views2 answers
Sql trigger difference between for and after
SQL
6 votes335 views2 answers
Find mysql version linux
SQL
2 votes296 views1 answer
Foreign key example in dbms
SQL

Share