/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

21 votes130 views4 answers
Oracle add column
SQL
0 vote151 views1 answer
Day of the week sqlite
SQL
2 votes119 views1 answer
Oracle drop table free up space
SQL
0 vote119 views1 answer
R dbConnect(odbc::odbc() to ms sql server remote
SQL
0 vote122 views1 answer
Double in sql server example
SQL
1 vote126 views2 answers
Test sqlsrv connection
SQL
0 vote124 views1 answer
Mysql terminal list table
SQL
18 votes113 views4 answers
Uninstall mysql ubuntu 18.04
SQL
0 vote125 views2 answers
T sql null or empty string
SQL
4 votes118 views1 answer
Fetch first 10 rows in oracle sql developer
SQL

Share