/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

4 votes296 views1 answer
Sql select limit range
SQL
7 votes258 views1 answer
Safe update mysql
SQL
0 vote269 views1 answer
Test the postgresql db connection
SQL
0 vote374 views5 answers
Right join
SQL
0 vote343 views1 answer
Php insert null mysql
SQL
12 votes248 views1 answer
Create column sql server
SQL
0 vote252 views1 answer
Mysql workbench not showing schemas
SQL
0 vote271 views1 answer
Mysql calculated column
SQL
3 votes251 views2 answers
How to View column names of a table in SQL
SQL
0 vote221 views1 answer
Count char in java
SQL

Share