By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,871 Members | 2,304 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,871 IT Pros & Developers. It's quick & easy.

I need help building a junction table out of two tables

P: 1
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?
Oct 24 '14 #1
Share this Question
Share on Google+
2 Replies


Expert 100+
P: 1,035

Frinavale
Expert Mod 5K+
P: 9,731
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.
Oct 28 '14 #3

Post your reply

Sign in to post your reply or Sign up for a free account.