Would it be practical to leave the record in the table and mark it as
unused? That would certainly simplify the whole business.
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -----Original Message-----
> From: Kory Wheatley [mailto:wheakorypersonal@stripped]
> Sent: Monday, November 13, 2006 12:51 PM
> To: mysql@stripped
> Subject: Find next available number for gidnumbers and uidnumbers
> I need some advice. We currently are in the process of
> starting to use LDAP for our accounts to authenticate. Now
> when I create a new LDAP account I need to assign a free
> gidnumber and uidnumber which can be to 1 to 9999999. My
> plan is to load all gidnumbers and uidnumbers that are being
> used into two separate mysql tables. What command could I
> use to find the first number that is not being used or not in
> the database?.
> Now sometimes it could be 12 or the very highest number,
> because when accounts are deleted these numbers will be
> removed from the tables, so I need to find the next available number.