/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 vote202 views2 answers
Datetrunc hour snowflake
SQL
0 vote175 views2 answers
Delete query sql server
SQL
6 votes207 views2 answers
Oracle undotbs usage
SQL
1 vote184 views1 answer
Adding indexing on a db model in mysql using sequelize
SQL
2 votes198 views1 answer
Oracle index size
SQL
-2 votes187 views3 answers
Oracle tablespace usage
SQL
0 vote149 views1 answer
Psql not found windows
SQL
6 votes196 views1 answer
Sqlite foreign key
SQL
0 vote164 views1 answer
Postgresql add leading zeros
SQL
4 votes210 views3 answers
Rename table column postgresql
SQL

Share