/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

-1 vote57 views3 answers
Ubuntu install mssql
SQL
0 vote110 views2 answers
How to use aggregate functions in sql
SQL
7 votes108 views4 answers
What is my mysql version
SQL
4 votes106 views1 answer
Datepart postgres
SQL
0 vote113 views1 answer
Oracle array
SQL
3 votes110 views1 answer
How to find names includes in sql
SQL
0 vote55 views1 answer
FindAllBy
SQL
1 vote108 views1 answer
Generate random data postgresql
SQL
16 votes117 views1 answer
CTE statement sql server
SQL
0 vote131 views2 answers
Plpgsql
SQL

Share