/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 vote188 views1 answer
Mysql sort by date column
SQL
1 vote213 views3 answers
Rows, INSERT INTO
SQL
0 vote207 views1 answer
Changing name of column and datatype in sql
SQL
0 vote192 views1 answer
Select from another database
SQL
0 vote227 views2 answers
Start mysql server using docker
SQL
0 vote208 views2 answers
Add colum in sql
SQL
1 vote217 views1 answer
Mysql workbench requires visual c++ 2019 redistributable package
SQL
0 vote186 views1 answer
Pl sql search in all packages
SQL
0 vote223 views1 answer
Postrgesql concat 2 columns divided by ;
SQL
0 vote175 views1 answer
Ms Sql set us timezone
SQL

Share