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: MySQL Mailing List Subject: autoincrement problem 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 1 abc 2 bcd 3 cde . . . . . . 9 xyz now if 2nd and 3rd rows are deleted, an autoincrement field will still assign 10, 11, 12.... to the new values, while I want it to assign the values deleted from the table first. What will be the best way to implement it? Thanks in advance Nitin --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.703 / Virus Database: 459 - Release Date: 6/10/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.703 / Virus Database: 459 - Release Date: 6/10/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
