/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 vote255 views1 answer
Mysql readable output
SQL
-1 vote167 views2 answers
Get day in sql
SQL
0 vote175 views1 answer
Python mysql show databases
SQL
61 votes1.2K views6 answers
Mysql add column
SQL
8 votes170 views1 answer
Oracle find text in functions
SQL
3 votes212 views1 answer
Export postgres database linux
SQL
0 vote228 views1 answer
Ora 00001 error catch plsql
SQL
0 vote164 views1 answer
Postgres call view
SQL
1 vote177 views1 answer
Update foreign key value in mysql
SQL
5 votes155 views2 answers
Create table
SQL

Share