On Mon, 15 Jul 2002 16:07:53 +0100, Roger Burton West wrote:
> On or about Mon, Jul 15, 2002 at 04:03:41PM +0100, Mark Fowler typed:
> >Without starting a massive database war, is there anyway to get mysql to
> >forget about autoincremented values.
>
> IME the way MySQL generates an auto-increment value is to SELECT
> MAX(value)+1. So deleting the values should be enough.
Well, I'm glad I don't use MySQL, then.
Surely you shouldn't rely on sequences being contiguous, anyway? Who cares
if your test eats up some values; their only purpose should be to ensure
uniqueness.
--
Peter Haworth [EMAIL PROTECTED]
"... It beeped and said ``Countdown initiated.'' Is that bad?"
