I was wondering if people is asking this in the belief that the
autoincrement field is the record position in the database table and that by
not reusing those positions, the space of the deleted records is wasted.
Perhaps when they say renumbering what they are meaning is compacting the
database reusing the empty slots they assume those autoincrement fields
point to. Someone remembers dBaseIII .dbf files? Well, perhaps that is the
picture they have in mind.
Satyam
----- Original Message -----
From: "Jay Blanchard" <jblanchard@xxxxxxxxxx>
To: "Steve Finkelstein" <sf@xxxxxxxxxxxxx>; "php-general"
<php-general@xxxxxxxxxxxxx>
Sent: Tuesday, September 04, 2007 12:53 PM
Subject: RE: Dealing with auto-increment in MySQL
[snip]
Do you use logic in your code to find a missing ID and insert new
records
based on that? Or do you just ignore it, let mysql handle the numbering
and
go on with your lives?
[/snip]
The answer is B. There is a long standing discussion on this right now.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.485 / Virus Database: 269.13.3/986 - Release Date: 03/09/2007
9:31
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
