I can understand not wanting to have holes, but..
If it is a primary key, how are you going to handle updating tables that
rely on that key id?
If your id numbers were to shift, like you want, and you had a related sub
table (one to many) and this was say, an shopping cart, then all of a sudden
customer A's line items are showing up in Customer B's and not customer A's
It is more common to to have reliable unique no shifting keys.
You can program in some logic that deletes all related records in related
tables, and then re-uses numbers if you want to 'fill' the holes, butis it
really worth it?
Holes are merely an aesthetic item in the vast majority of cases.
Auto_increment behavior is clearly documented in the manual.
On 4/8/01 9:35 AM, "David" <[EMAIL PROTECTED]> wrote:
> I have a primary key listed as ID
>
> When I first added about 10 records and then deleted a few records and
> then added more records it didn't replace the missing records.
>
> When I select all records to view I now get:
>
> 1
> 2 why didn't it go to 3, 4 and 5 after 2?
> 6
> 7
> 8
>
>
>
> When I add a record it becomes record 11. Am I doing something wrong
> when I delete a record? I thought it would move the other records down
> 6 and 7 would be 3 and 4 etc...
>
> Using RedHat Linux with latest MySQL rpms: mysql-server-3.23.32-1.7
> php-mysql-4.0.4pl1-3
> mysql-devel-3.23.32-1.7
> mysqlclient9-3.23.22-3
> mysql-3.23.32-1.7
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
