/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 vote245 views1 answer
Psql show with user is logged in
SQL
0 vote306 views1 answer
Influxdb list all tags for a measurement
SQL
6 votes296 views2 answers
Postgresql database url
SQL
6 votes255 views3 answers
Mysql server is not starting xampp
SQL
0 vote270 views1 answer
What is ssrs and ssis in sql server
SQL
-1 vote301 views1 answer
Create view in mysql workbench
SQL
0 vote249 views1 answer
Month mysql
SQL
21 votes283 views6 answers
Change column in mysql
SQL
0 vote288 views2 answers
Faster mysql imports
SQL
0 vote219 views1 answer
Denied
SQL

Share