| Welcome to WebmasterWorld Guest from 126.96.36.199 |
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
|Become a Pro Member|
|Figuring next auto incremented ID to be|
knowing that an unknown bunch of rows were deleted
How will you figure ahead of time what will be the next incremented id when a bunch of previous ID were deleted
example (in a perfect world!)
existing ID is 1, so we know that the next will be 2
eample (in my scenario)
existing ID could be 5, then a few more rows were added, say 6 to 10
but then later 6 to 10 are deleted
so one may think that the next ID could be 6 since the last row reads 5
but as we know the very next will start above the last deleted row
and the new ID will become 11
Is there a way to figure it out before that last newer row will be added?
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved