/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 vote340 views1 answer
Get who is hired in february in sql
SQL
18 votes324 views6 answers
Mysql create table
SQL
1 vote318 views1 answer
Set statistics on in ssms
SQL
0 vote329 views1 answer
Sql list dates between two dates
SQL
1 vote317 views2 answers
DROP TABLes regardless of constraints
SQL
1 vote332 views1 answer
How to install mysql 8.0 windows service
SQL
0 vote340 views3 answers
Select random sql
SQL
3 votes362 views2 answers
Check data in table mysql
SQL
4 votes325 views1 answer
Oracle select first 10 rows
SQL
1 vote338 views1 answer
How to unlock table in mysql
SQL

Share