List:General Discussion« Previous MessageNext Message »
From:Daevid Vincent Date:June 26 2003 12:04am
Subject:RE: Setting default auto_increment start int
View as plain text  
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
> 

Thread
Setting default auto_increment start intJavan B.25 Jun
  • Re: Setting default auto_increment start intEgor Egorov25 Jun
    • RE: Setting default auto_increment start intDaevid Vincent26 Jun