James --
You haven't done enough "book work" this is basic db design stuff,
covered in Dubois book and evey other, the short answer is:
Primary Key -> foriegn Keys i.e
People table:
person_id, # Primary key, unique and auto increment
fname
lname
...
Food
person_id # pulled from People table via select statement
# Index Not unique, NOT auto inecremented
food_index # Primary key, unique and auto increment
More important, How do you want to search this tables.
i.e. first, last, food ..etc think indexing.
Final thought, do you want to pull food names from anothe
table?
David
>
>
> Hello,
>
> I have a relatively simple question to ask. Any help is
> great appreciated.
>
> Let us say that I want to create a classic table
> that would have columns for a persons name, eye color,
> age, etc.
>
> However, I also want to store a list (somewhere) of that particular
> persons favorite foods (which can grow to be several hundred
> entries). I realize that there could be many ways of doing this,
> but what is the 'most effective' method? I have the DuBois mySQL
> book if anyone could cite any references.
>
>
> Thank you,
>
> Jim
>
> P.S. you're all doing great job with the
> development of mySQL. I tip my hat.
>
>
> ---------------------------------------------------------------------
> 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
---------------------------------------------------------------------
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
