If you do want to delete stuff MySQL shouldn't reuse the auto_inc. DO NOT reset the database unless you've been doing testing and such and are now going live (and even then it's questionable).

Of course for MyISAM it don't matter anyway.<BR><BR>If you don't need sequentiality, auto_increment can be used as part of a multi-value key and should do the right thing in your case.