/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 vote210 views1 answer
Mysql 5.6 hierarchical recursive query
SQL
1 vote208 views1 answer
Best sql course
SQL
0 vote253 views1 answer
Mql5 datetime get hour
SQL
0 vote160 views1 answer
Procedures and functions in pl/sql
SQL
19 votes192 views2 answers
Mysql add column after another
SQL
1 vote196 views1 answer
Postgresql substring last
SQL
0 vote208 views1 answer
Gcloud sql list databases
SQL
0 vote186 views1 answer
Postgres call view
SQL
8 votes192 views5 answers
Alter table add column with default value
SQL
0 vote201 views1 answer
Is there a way to use read_sql_query and the query has WHERE column = Variable?
SQL

Share