List:General Discussion« Previous MessageNext Message »
From:Victoria Reznichenko Date:January 28 2003 9:27am
Subject:re: question about primary key
View as plain text  
On Monday 27 January 2003 10:27, Vicente Valero wrote:

> 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,...)?

No, you can't do this automatically.


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   Victoria.Reznichenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
       <___/   www.mysql.com




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