>>>>> "JSG" == Josh S Gough <dasjsg@stripped> writes:
JSG> However, mine doesn't care about the table being emptied, it will just
JSG> take the largest value and add one to it, so when I then delete the
JSG> largest value, inserting a new record takes that largest value again.
JSG> This isn't what I want and from some posts I've read, it shouldn't do this
JSG> at all actually.
But that's how auto_increment is defined: it returns one higher than
the highest current value for that numeric field.
If that's not what you want, then you'll need to create a separate
table of a single integer with one row in it that you lock, increment,
and unlock. Then use the value from that table as your "next" value.
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/