HI,
Yes, but unfortunately, you need to upgrade to 3.23 to get this behavior.
Regards
Quentin
-----Original Message-----
From: luisma [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 18 January 2001 12:03
To: [EMAIL PROTECTED]
Subject: AUTO_INCREMENT question
I have a column, lets say "id", that is AUTO_INCREMENT. In it the most
recently
inserted row got an ID value of 100.
Now, lets say I kill off some rows from before, and crunch down the
IDs
so that there are no skips in numbers, and now the most recently
inserted
row has an ID of 85.
When I instert a new row, the new ID will get a value of 101, as opposed
to
86. Is there any way of resseting the auto_increment index so that I
could
get
one greater than the greatest current id whenever I
insert?
thanks
The information contained in this email is privileged and confidential
and intended for the addressee only. If you are not the intended
recipient, you are asked to respect that confidentiality and not
disclose, copy or make use of its contents. If received in error
you are asked to destroy this email and contact the sender immediately.
Your assistance is appreciated.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
