/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 vote341 views1 answer
Varchar format not case sensitive sql
SQL
1 vote339 views1 answer
Mysql select month and year
SQL
7 votes351 views3 answers
How ot change name of column mysql
SQL
-1 vote371 views1 answer
Sql select data from one database and insert into a different database
SQL
25 votes428 views4 answers
Import mysql dump command line
SQL
20 votes334 views5 answers
Mysql reset auto increment to 1
SQL
0 vote348 views1 answer
UNION ALL LEFT JOIN
SQL
0 vote334 views1 answer
Mysql illegal mix of collations for operation 'concat'
SQL
-1 vote331 views1 answer
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.8.0.
SQL
2 votes345 views1 answer
Oracle drop sequence if exists
SQL

Share