/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 vote162 views1 answer
Alter constraint in sql
SQL
0 vote150 views1 answer
Sqlplus change user
SQL
0 vote110 views2 answers
Https://www.google.com/search?ei=bihqX_v9DJb--gTYoLH4DQ
SQL
0 vote154 views1 answer
Select a row include list of array with join table SQL
SQL
0 vote138 views1 answer
Kotlin sqlite delete row
SQL
0 vote142 views1 answer
Postgresql parse json array
SQL
0 vote151 views1 answer
Get record which is available in one table but not in another mysql
SQL
4 votes137 views2 answers
Tsql utf to local time
SQL
6 votes1.3K views1 answer
Sql select second max
SQL
0 vote187 views1 answer
Liquibase update row
SQL

Share