>>>>> "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/