AUTO_INCREMENT: non-breakable numeric suite

[Ismael Touama]

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.