mySQL table/entry reuse

[tonyw]

ok, if i have a table like this :

"CREATE TABLE groups
(
group_id int unsigned not null auto_increment,
PRIMARY KEY(group_id)
)";

and I delete entries from it is there anyway to get deleted slots reused? e.g. If I delete group_id=10 can i make a subsequent addition to the table reuse slot 10?

thanks

(retrospective appologies for posting in the wrong forum...)

[bastien]

autoincrement does not work that way...you cannot reuse those slots....unless you change the field to a number and can control the number being used....

autoincrements will continue in order with each entry...it is best not to screw with it either...that'll leave you with endless headaches later...