MySQL compacting
| From: | Rock Kake | Date: | Sun, 11 Feb 2001 08:40:15 +0000 |
| Subject: | MySQL compacting | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-6534@lists.php.net to get a copy of this message | ||
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 that the record numbers are
shifted down, or the database should intelligently fill the gap where the
old record is.
Are there any good articles that deal with this topic specifically?
--
Rock Kake
------------------