/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 vote242 views1 answer
Mysql random number between 1 and 100
SQL
36 votes258 views3 answers
Add column in mysq
SQL
3 votes228 views2 answers
Sqlite show table definition
SQL
2 votes239 views1 answer
Add default sql server
SQL
2 votes232 views2 answers
Get all columns from table sql
SQL
0 vote237 views1 answer
Import big data to mysql
SQL
0 vote223 views1 answer
Sql server update top n records
SQL
0 vote247 views1 answer
Mysql query to select the highest value
SQL
0 vote259 views1 answer
Full outer join in mariadb mysql
SQL
0 vote242 views1 answer
Select row with latest date mysql
SQL

Share