True.
The only thing that could be done is write a UDF (user-defined function),
which accepts a table and field name as parameters and somehow manages
to find the first unused ID in that table.. and hope it is atomic, too..
I don't think this is too easy to do, though :)
G'luck,
Peter
--
Hey, out there - is it *you* reading me, or is it someone else?
On Fri, May 04, 2001 at 02:01:42PM +0200, Bruce Stewart wrote:
> I believe that this behaviour is standard for autoincrementing fields on all
> database systems that support them.
>
> -----Original Message-----
> From: Stefan Wehowsky [mailto:[EMAIL PROTECTED]]
> Sent: Fri, 04 May 2001 10:37
> To: [EMAIL PROTECTED]
> Subject: auto_increment
>
>
> Let's say I got a column "id" that is of type tinyint and has the extra
> "auto_increment". Let's further say that I have 50 entries in that
> column. Now if I delete e.g. entry No. 30 and right after that add
> another entry without naming an id (for ist auto_increment) MySQL gives
> it the id 51 AND NOT 30 which leads to more and more gaps between the
> id's. Is there anything i can do about that ?
---------------------------------------------------------------------
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
