Hi,
There is no other go.I too had similar problems.But it
does not hurt me as the auto_increment column is
always being used as a primary key in my case.
We have got to live with it until and unless we have
some option to insert into the deleted row.
Regards,
Ravi
--- Joseph Bueno <[EMAIL PROTECTED]> wrote: >
Stefan Wehowsky wrote:
> >
> > 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 ?
> >
>
> No.
>
> Also, don't use TINYINT unless you are sure that you
> will never insert
> more than 127 records !
>
> (Both issues have already been discussed in this
> mailing list, check
> the archives for more details).
>
> > Best regards,
> >
> > Stefan Wehowsky
> >
>
> Best Regards
> --
> Joseph Bueno
> NetClub/Trader.com
>
>
---------------------------------------------------------------------
> 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
>
____________________________________________________________
Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie
---------------------------------------------------------------------
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