Using set with values from a table
Posted
by gozzilli
on Stack Overflow
See other posts from Stack Overflow
or by gozzilli
Published on 2010-04-05T17:31:16Z
Indexed on
2010/04/05
17:33 UTC
Read the original article
Hit count: 318
I'm writing a database of all DVDs I have at home.
One of the fields, actors
, I would like it to be a set of values from an other table, which is storing actors. So for every film I want to store a list of actors, all of which selected from a list of actors, taken from a different table.
Is it possible? How do I do this? It would be a set of foreign keys basically.
I'm using a MySQL database for a Django application (python), so any hint in SQL or Python would be much appreciated.
I hope the question is clear, many thanks.
© Stack Overflow or respective owner