From: Ismael Touama
Date: June 7 2001 10:22am
Subject: AUTO_INCREMENT: non-breakable numeric suite
List-Archive: http://lists.mysql.com/win32/6368
Message-Id: <DGEPILFKJJPHMFPFNODKEELBCAAA.ismael.touama@install.fr>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 8bit

Hi List,

I don't understand the way to create an int field with AUTO_INCREMENT
'option' taht is always continue even if I delete some records.
I don't want any hole in my suite.
I'm with version 3.23.38.
My field is MEDIUMINT UNSIGNED AUTO_INCREMENT.It' not an INDEX
I' m little bit confuse with LAST_INSERT_ID() and the following instruction
"DELETE FROM tbl_name WHERE 1>0".
I think I could write a function by myself with "select count(*) from
tbl_name..." but it may be not really optimized.
What's the more easy and practice function to use?

Thanks for tips.
Ismaël.