/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 vote165 views1 answer
Access denied for user 'root'@'localhost' workbench ubuntu
SQL
13 votes162 views6 answers
Mysql update from select
SQL
0 vote161 views1 answer
Teller stamp , bmo , PDF
SQL
2 votes182 views1 answer
Oracle drop sequence if exists
SQL
0 vote185 views1 answer
Sql get highest date from 3 tabels
SQL
3 votes167 views2 answers
SqlMessage: "Host '192.168.64.1' is not allowed to connect to this MariaDB server
SQL
-2 votes174 views1 answer
Modify column name in tsql
SQL
0 vote196 views1 answer
TSQL function split string
SQL
11 votes171 views1 answer
Sql query to find duplicates in column
SQL
-1 vote177 views1 answer
Adding a new table psql
SQL

Share