/SQL/Delete auto increment mysql

Delete auto increment mysql

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

1

Source: grepper.com

Mysql remove auto increment

ALTER TABLE mytable CHANGE my_col my_col INT(10) UNSIGNED NOT NULL

0

Source: sitepoint.com

Similar codes

0 vote313 views1 answer
Select row with latest date mysql
SQL
0 vote302 views1 answer
Recover deleted data from mysql database
SQL
0 vote296 views1 answer
What is the use of index in mysql table
SQL
2 votes302 views2 answers
Postgres select duplicate columns
SQL
2 votes313 views1 answer
Mysql ALTER TABLE ADD COLUMN BOOLEAN AFTER DEFAULT "1";
SQL
1 vote313 views1 answer
Woocommerce mysql price table
SQL
0 vote316 views1 answer
Sql on-premises
SQL
0 vote324 views1 answer
Openquery join two tables
SQL
0 vote331 views1 answer
Create table in dbms cmds
SQL
0 vote358 views1 answer
Mysql get nth highest
SQL

Share