For your problem, you need to create a table with a pool of availables
key, and when you use one, you delete from this table and when you don't
need it, return it here.
Osvaldo Sommmer
-Original Message-
From: Nitin [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 12, 2004 3:44 AM
To: MySQ
MySQL Mailing List"
<[EMAIL PROTECTED]>
Sent: Saturday, June 12, 2004 3:53 PM
Subject: Re: autoincrement problem
> Nitin wrote:
>
> >Hi all,
> >
> >What will be the best way to implement auto increment field. I dont want
to use auto increment feature, as it on
Nitin wrote:
Hi all,
What will be the best way to implement auto increment field. I dont want to use auto
increment feature, as it only appends the numbers but doesn't check for the values
deleted. Suppose, following are the values in table
1abc
2bcd
3cde
..
..
..
9xyz
