/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 vote140 views1 answer
Sql server select top 2 of each group
SQL
24 votes132 views6 answers
Rename a column in sql server
SQL
0 vote144 views1 answer
Convert excel into sqllite db using python
SQL
1 vote145 views1 answer
Mysql find most common value
SQL
0 vote140 views1 answer
Postgres can integer fields be negative
SQL
0 vote136 views1 answer
Can't connect to postgresql mac os
SQL
-1 vote174 views3 answers
Error: mysql shutdown unexpectedly.
SQL
0 vote142 views1 answer
T-sql update table variale
SQL
2 votes133 views1 answer
Mysql sysdate
SQL
0 vote156 views2 answers
Mysql dump structure only
SQL

Share