If you are not using them as foreign keys, how does it matter? They are simply identifiers for a particular record. If you need to know the number of records a select count(*) does that quickly enough, gaps are irrelevant.
Miles
At 03:38 PM 2/16/2003 -0500, Willie G wrote:
Miles, I never use auto increment. Not because of gaps, but in case I need to reload the table. They do have meaning if they are foreign keys to another table.- Larry -----Original Message----- From: Miles Thompson [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 16, 2003 1:14 PM To: Phillip S. Baker; PHP Email List Subject: Re: [PHP] Inserting records in a particular way in MySQL Phillip, It doesn't matter, obviously you're not using the autoincrement ID for a foreign key. All this does is identify a record. If you did a SELECT and found a missing sequence number, what's to say that value would not be inserted by another user before your INSERT? If you have not set up the table with a MyISAM, MySQL will eventually use the missing numbers. These are only identifying tags, with no intrinsic meaning. Miles At 09:37 AM 2/16/2003 -0800, Phillip S. Baker wrote: >Greetings all, > >I have some PHP code that is inserting records into a DB. >Most of this is auto increment. > >However I know there is allot of breaks in the sequencing. > >I am wondering if there is some way to write the SQL code to search >through the existing records in the DB and to find where the next >available ID is instead of just inserting the next sequence. > >So for example if the ID's are. > >20453 >20454 >20458 >20459 > >It would let me know that 20455 is available for use and use the ID number >instead of using 20460 >Thanks all. > > >Phillip > ><snip overly long sig> > >-- >PHP General Mailing List (http://www.php.net/) >To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
