/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 views3 answers
Mysqli count down
SQL
0 vote319 views1 answer
Oracle allow space to user
SQL
0 vote409 views1 answer
Mysql show schema
SQL
1 vote348 views1 answer
Second last highest id in sql
SQL
3 votes311 views4 answers
Show columns from table
SQL
0 vote371 views1 answer
Drop view in mysql
SQL
0 vote335 views1 answer
Postgres select from values
SQL
1 vote369 views1 answer
Mysql update inner
SQL
2 votes274 views1 answer
Sql view column data type
SQL
1 vote295 views1 answer
Select random sample sql
SQL

Share