Where does the system store the current cat_id?

[gustav]

Hi.

Well, I just deleted 100 categories... and only have the 5 first left..... but now, when I create a new category, the system want's to start at cat_id 106. But as all my left categories are 1,2,3,4,5, I would like the system to continue again whith cat_id 6.... but whatever I do, it always want's to create a category whith an ID >105..... where does the system store or chace this number? So that I can reset it to the value I need?

Thnx

[Jenn]

http://www.4homepages.de/forum/index.php?topic=8930.0

[gustav]

Well, ok... found the solution in the mySQL docs.......

Code: [Select]

ALTER TABLE tbl AUTO_INCREMENT = xxx where tbl is the name of the table and xxx is the value you wanna set the current autoincrement to.