Would it be practical to leave the record in the table and mark it as unused? That would certainly simplify the whole business.
Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 > -----Original Message----- > From: Kory Wheatley [mailto:[EMAIL PROTECTED] > Sent: Monday, November 13, 2006 12:51 PM > To: mysql@lists.mysql.com > 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. > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
