/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 vote172 views1 answer
Execut sql python
SQL
1 vote193 views2 answers
Rebuild index sql server
SQL
0 vote133 views1 answer
Kannst du deine finger trainieren
SQL
1 vote194 views1 answer
Sql find column name like
SQL
5 votes188 views1 answer
Sql check if date is between 2 dates
SQL
1 vote194 views1 answer
How to see all table partition in oracle
SQL
4 votes179 views1 answer
Change nls_date_format
SQL
1 vote176 views1 answer
Create procedure with encryption
SQL
1 vote193 views1 answer
Tsql update datetime
SQL
0 vote175 views1 answer
Sql server alter table column nullable
SQL

Share