DB : ID attribution question

[KhaN]

It look like DB always remember what ID is needed. Like if my last ID is 46 in "NPC_TYPE", i spawn 4 mobs, then i want to remove one. DB wont attrib ID 49, but 50. Is there a way to fix this ? so DB will attrib ID next to the last one ? ... humm i wonder if its clear.

[Derision]

I was perusing the mysql documentation and:

ALTER TABLE tbl_name AUTO_INCREMENT = value

might be what you want, e.g.

ALTER TABLE npc_types AUTO_INCREMENT=49;

I've not tried it, and I would backup your db first if you do plan on trying it, just to be on the safe side :)

[KhaN]

Thanks Derision, it work perfectly :)