Re: [PHP-DB] MySQL compacting

2001-02-12 Thread JJeffman
I'm afraid there is no articles on this matter. You are facing a database design matter. Auto-increment primary keys must haven't any meaning other than just be the primary key and relate one table to another, if you had a function to "update" the auto-increment field to eliminate the holes that

[PHP-DB] MySQL compacting

2001-02-11 Thread Rock Kake
Is there any way to add/delete from a MySQL database using PHP3/4 without leaving blank records? e.g. if record number 3 is deleted and there are 5 records in the database, and you have auto-increment as true, if you add a record it will go in as 6. Either the database should be compacted so