I need help building a junction table out of two tables

[chuyg12]

Ok so I need to build a junction table out of an my_interests table that I created and my_contacts table. I have interests_id and contacts_id as primary keys on those tables. Im basically stuck. Can anyone help? Oh and by the way I am using MySQL workbench?

[Luuk]

See '3.2 Many-To-Many Relationship' of this MySQL Tutorial

[Frinavale]

I'm not sure what you need help with?
Do you need help with the Create Table command?
Do you need help with understand the concept of a join/junction/lookup table?


If you need help understand the concept, you should probably look up the topic of database normalization. There is a pretty good article on this topic here on this forum that you can find by going to this link: Database Normalization and Table Structures.