/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 vote180 views1 answer
Oracle execute package dblink
SQL
0 vote119 views1 answer
Import csv to mysql
SQL
49 votes258 views6 answers
Mysql add column to table
SQL
1 vote186 views1 answer
Varchar plsql
SQL
0 vote148 views1 answer
Replace multiple string in query sql
SQL
2 votes152 views2 answers
TSQL GET ALL COLUMNS IN TABLE
SQL
0 vote158 views1 answer
Heidisql check how much space a row
SQL
0 vote170 views1 answer
Select year from dual oracle
SQL
-1 vote211 views1 answer
Add 10 to all numbers in a column sql
SQL
3 votes158 views1 answer
Start mysql server by terminal in linux
SQL

Share