question about primary key

[Vicente Valero]

Hello, I need help.

I want to create a table with a numeric primary key as index in my sql. I
want this
index will be automatic. I've tried an auto_increment column, but if insert
a non-correlative value then all new entries continue from this
non-correlative value (1,2,3,4,1026,1027,...). It is possible use the first
value not-used in the column automatically (1,2,3,1026,4,5,1000,6,7,...)?

Thank you,
Vicente

___________________________________________________
Yahoo! Móviles
Personaliza tu móvil con tu logo y melodía favorito 
en http://moviles.yahoo.es