Thank goodness this is the position. If the capability of
reordering the auto_increment existed, we could potentially
have all of our databases broken by some inadvertant finger trouble.
As you mentioned, there are better ways to handle this perceived
"problem", which appears that the auto_increment is being used
for a purpose it was not intended for...
---------------------------
Tonu Samuel wrote:
>
> Kif wrote:
>
> > Hi
> > ANy idea how i can get my auto_increment fields to renumber themselves after
>deletion of records so that they all get re-ordered and run consecutively from 1 to
>whatever without any numbers missing ?
> > Please help if you know how to do this
>
> I think we never will implement such stuff. auto_increment responsibility is to be
>unique and it should never
> appear back again when issued once. Idea is to identify record in database. If
>someone have right to reorder
> one table then relationships to other tables will be broken. auto_increment is
>totally technical field and if you
> do not like holes in it, programmer should use separate column for user-readable
>values additionally to auto_increment.
--------------------------------
--
Justin Farnsworth
Eye Integrated Communications
321 South Evans - Suite 203
Greenville, NC 27858 | Tel: (252) 353-0722
---------------------------------------------------------------------
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
