/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

7 votes267 views4 answers
What is my mysql version
SQL
3 votes244 views1 answer
Delete all content in table mysql
SQL
0 vote242 views1 answer
Difference between cross apply and inner join
SQL
0 vote268 views1 answer
SQL query to verify the size of the table
SQL
0 vote260 views1 answer
Sql ignore
SQL
11 votes251 views2 answers
Docker create postgres db
SQL
0 vote251 views1 answer
Events not working db
SQL
0 vote275 views1 answer
Max length found in mysql
SQL
10 votes276 views2 answers
Tsql merge example
SQL
1 vote258 views2 answers
Insert sqlite
SQL

Share