On 29-Aug-01, Paul DuBois wrote:
> Create a single PRIMARY KEY that consists of the two columns chapter and
> section, and make section an AUTO_INCREMENT column. When you insert
> rows, set chapter to the proper chapter number and section to NULL.
> This will cause MySQL to generate independent sequences for each chapter.
> (In essence, you have multiple sequences within the same table.)
>
> This requires that you have MySQL 3.22.25 or later. That's when this
> feature was introduced.
That's odd. There's nothing about it in the changelog for 3.22.25 in the
documentation, and the only reference to this behavior I've been able to
find in the manual is this (from the chapter on MyIsam): "Note that when
an AUTO_INCREMENT is defined on the end of a multi-part-key the old
behavior is still present."
I hate having to ask for this, but could you please point me to the
chapter in the manual where this is discussed? I just can't seem to
find it. :-P
//C
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga user since '89, and damned proud of it too.
---------------------------------------------------------------------
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
