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
