List:General Discussion« Previous MessageNext Message »
From:Vicente Valero Date:January 27 2003 8:27am
Subject:question about primary key
View as plain text  
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
Thread
question about primary keyVicente Valero27 Jan
  • re: question about primary keyVictoria Reznichenko28 Jan
    • mysql dump for remote dbMark Stringham28 Jan
      • Re: mysql dump for remote dbNicholas Stuart28 Jan
      • Re: mysql dump for remote dbZak Greant28 Jan
      • Re: mysql dump for remote dbDavid T-G29 Jan
  • Re: question about primary keyDavid T-G28 Jan
Re: mysql dump for remote dbDan Nelson28 Jan
Re: mysql dump for remote dbMark Stringham29 Jan
  • Re: mysql dump for remote dbDavid T-G29 Jan
Re: mysql dump for remote dbMark Stringham29 Jan