troubleshooting Question

How can I create a many to many relationship in mysql?

Avatar of FairyBusiness
FairyBusinessFlag for United States of America asked on
MySQL Server
22 Comments7 Solutions771 ViewsLast Modified:
Hi, my professor this last semester showed us how to do a many to many relationship in MySQL, but he only used 1 day to go over it and I did not fully understand it at the time. So now I need to have a many to many relationship, but I am not sure how to create this. (trying to avoid listed fields) Not even sure where to start.  (I have only ever done one to many relationships)

If someone could please describe a SIMPLE way of doing this, or knows of a SIMPLE tutorial that would be great!
ASKER CERTIFIED SOLUTION
Kent Olsen
Data Warehouse / Database Architect

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 7 Answers and 22 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 7 Answers and 22 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros