List:General Discussion« Previous MessageNext Message »
From:Vivek Khera Date:April 7 1999 9:48pm
Subject:Re: how to start counting at a specific number?
View as plain text  
>>>>> "SB" == Shaun Batterton <shaunb@stripped> writes:

No, you are wrong.  Please show a test case that exhibits the behavior 
you claim.


SB> Interestingly, if you let mysql autoincrement for the first insert,
SB> then  it will always autoincrement starting at the lowest available
SB> number.  For example, the first few auto-inserts were like:

SB> auto-col
SB> --------
SB> 1
SB> 2
SB> 3
SB> 4

SB> but after removing 1 and 2, the next autoincrement will start at 1, so
SB> it will look like

SB> auto-col
SB> --------
SB> 3
SB> 4
SB> 1


								v.

-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera@stripped       Rockville, MD       +1-301-545-6996
PGP & MIME spoken here            http://www.kciLink.com/home/khera/
Thread
how to start counting at a specific number?Daevid Vincent7 Apr
  • Re: how to start counting at a specific number?Thimble Smith7 Apr
  • Re: how to start counting at a specific number?Shaun Batterton8 Apr
    • Re: how to start counting at a specific number?Vivek Khera8 Apr
  • Re: how to start counting at a specific number?Shaun Batterton8 Apr
    • Re: how to start counting at a specific number?Thimble Smith8 Apr