im confused here , i create a table and have 2 columns id and name.
Now id is primary key , not null and auto increment.
Suppose i fire:
insert into table (name) values('test');
this will give me:
1 | test
Now if i fire :
alter table table_name auto_increment = 5;
this will populate id with 5 on next insert.
now if i delete value of id =5 and again re-insert :
insert into table (name) values ('test2');
it gives me :
6 | test2
why it doesn't give me 5 again?
Also is it not possible that we can't reset the existing auto_increment values to desired one in MySql?