/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 vote132 views1 answer
Mysql timediff
SQL
0 vote129 views2 answers
Select limit ms sql
SQL
5 votes133 views1 answer
Add column table sql default value
SQL
0 vote144 views1 answer
Group by max date
SQL
0 vote143 views1 answer
How to print sql query
SQL
0 vote124 views1 answer
Sql server inner join convert collation
SQL
0 vote147 views1 answer
Drop table BigQuery table columns
SQL
0 vote149 views1 answer
Postgres get running query
SQL
10 votes128 views1 answer
Create table oracle
SQL
2 votes135 views1 answer
Sql ignore accents
SQL

Share