Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Many-to-many example
# For http://stackoverflow.com/a/7296873/396458
student: student_id, first_name, last_name
classes: class_id, name, teacher_id
student_classes: class_id, student_id # the junction table
students:
id | first | last
=====================
1 | John | Lee
2 | Jane | Wilson
3 | Daniel | Gomez
classes:
id | name | teacher_id
==========================
1 | Biology | 2
2 | Physics | 4
3 | English | 77
student_classes
s_id | c_id
======================
1 | 2 # John is taking Physics
1 | 3 # John is taking English
2 | 2 # Jane is taking Physics
3 | 1 # Daniel is taking Biology
@vinod023

This comment has been minimized.

Copy link

commented Mar 7, 2019

Relation ships means table creation or writing the queries combination of tables

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.