/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 vote278 views2 answers
Mysql error 1215
SQL
1 vote288 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL
0 vote347 views1 answer
Oracle simple quote
SQL
3 votes263 views1 answer
Sql multiple column index
SQL
0 vote267 views1 answer
2020 new year
SQL
0 vote264 views1 answer
SQL get max per id
SQL
17 votes272 views4 answers
Set mysql Password
SQL
0 vote286 views1 answer
Sql find record cannot cast date
SQL
0 vote282 views1 answer
Linebreak sql
SQL
0 vote276 views1 answer
Mysql change timestamp on update
SQL

Share