/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 vote312 views2 answers
Mysql on update current_timestamp
SQL
0 vote344 views1 answer
Error code 1451 sql
SQL
2 votes293 views1 answer
Add 2 hours to current time in MySQL
SQL
9 votes320 views4 answers
How to alter table column name in mysql
SQL
0 vote324 views1 answer
Is not numeric sql
SQL
2 votes325 views1 answer
Q operator in plsql
SQL
0 vote298 views1 answer
How to close external sql connection in laravel
SQL
3 votes301 views3 answers
Mysql order by list
SQL
0 vote283 views1 answer
Heavy table in mysql
SQL
4 votes342 views3 answers
Sql find second highest salary employee
SQL

Share