On Mon, Feb 26, 2001 at 04:23:23PM -0800, John Tsangaris wrote:
>
> If I turn on auto increment and let it do it's thing and then later
> on delete a few of the entries (let's say 1, 2, 3) and the current
> high entry has an id of 45.. why does mysql continue with 46 instead
> of using up 1, 2, and 3 first? Is there a way to bypass this?
Logically, going from 45 to 1 or 2 or 3 isn't an "increment", it's a
decrement.
If you never want holes in the series, then auto_increment may not be
the best option for you...
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878 Fax: (408) 530-5454
Cell: (408) 439-9951
---------------------------------------------------------------------
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
