I want to create a table with two Primary Keys. The first key is a category
field, and the second is auto-incremented. Example: Key 1=Chapter name, Key
2 =section number. For example, (Chapter1, 1) (Chapter1, 2) (Chapter1, 3)
then with a new Cheaper, I want to restart the auto-incremented field back
to 1 (Chapter2, 1) (Chapter2, 2). How do I get the auto-incrementer to
restart with each new chapter?
---------------------------------------------------------------------
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
