What I've done is insert a bogus record at ID 999, then the next one will be
1000 and upwards. You can then delete the 999 record if you wish. mySQL will
NOT fill in the 1-999 spots automatically.
> -----Original Message-----
> From: Egor Egorov [mailto:egor.egorov@stripped]
> Sent: Wednesday, June 25, 2003 3:50 AM
> To: mysql@stripped
> Subject: Re: Setting default auto_increment start int
>
>
> "Javan B." <javanbat@stripped> wrote:
> >
> > Just a quick question: How do I set the auto increment
> > for a field to start from an integer other than 1.
> >
> > For example, I would like to be able to have the auto
> > increment counter start from 1000.
> >
>
> Use AUTO_INCREMENT option of CREATE TABLE statement:
> http://www.mysql.com/doc/en/CREATE_TABLE.html
>
>
>
> --
> For technical support contracts, goto
> https://order.mysql.com/?ref=ensita
> This email is sponsored
> by Ensita.net http://www.ensita.net/
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Egor Egorov
> / /|_/ / // /\ \/ /_/ / /__ Egor.Egorov@stripped
> /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
> <___/ www.mysql.com
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?> unsub=daevid@stripped
>
