From: Martijn Tonies
Date: March 23 2006 4:24pm
Subject: Re: Question about autoincrement ID
List-Archive: http://lists.mysql.com/mysql/196098
Message-Id: <003f01c64e96$4f5ec670$cd02a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

>So I must do a big SELECT and then check my self every time (for each
INSERT),
>which IDs are free?

No, you just ignore "deleted" IDs.

What's the point?


Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com