I'm filling a database with info, and I'm using id as identifiers in the
list, the id is auto increment, and I deleted one entry, now I have a hole
in the database, is there any way to fix this?
lets say I have
And I deleted 6
Now it looks like
9 and so on
(snip auto-incrementing PKs)
is there somewhere the next number is located ?
No. Why would you care, anyway? The thing about PKs is that they have to be
unique, not sequential.
If you're *really* bothered by it, you'll have to dump the contents of the
table to a file, drop the
Mail list logo