/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 vote173 views1 answer
Mysql multiple count
SQL
12 votes170 views4 answers
Install mysql ubuntu 18.04
SQL
-1 vote142 views1 answer
Mysql if example
SQL
6 votes182 views3 answers
Mysql remove user privileges
SQL
1 vote174 views2 answers
Regex starts with
SQL
4 votes198 views2 answers
Float postgres
SQL
7 votes153 views1 answer
Mysql load data infile csv
SQL
0 vote166 views1 answer
Table values functions in SQL
SQL
0 vote159 views1 answer
Output to file mysql
SQL
17 votes178 views3 answers
Cast in sql server
SQL

Share