MySQL Forums :: Newbie :: Can Autoincrement find the next free number ?


Advanced Search

Can Autoincrement find the next free number ?
Posted by: Marco Muehleis ()
Date: February 23, 2010 09:38AM

Hi there !

My Problem is, i have a large table with articles in it. The Articlenumber is Autoincrement.

Now many people delete their articles and the articlenumber would be free now. To prevent the numbers to grow too high, i want to use a free number with the next "INSERT"-Command.
Is that possible ?

I wrote a skript that searches the next number but soon it took about 20 Sekonds to save a new Article.

Would thank you for ideas.

Yours
Marco

Options: ReplyQuote


Subject Written By Posted
Can Autoincrement find the next free number ? Marco Muehleis 02/23/2010 09:38AM
Re: Can Autoincrement find the next free number ? laptop alias 02/23/2010 04:10PM
Re: Can Autoincrement find the next free number ? wayne r 02/23/2010 05:18PM
Re: Can Autoincrement find the next free number ? Guelphdad Lake 02/24/2010 02:00PM
Re: Can Autoincrement find the next free number ? Markku Tiuri 02/25/2010 03:28AM
Re: Can Autoincrement find the next free number ? Guelphdad Lake 02/25/2010 08:38AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.