Lesson 8 - MySQL Step By Step: More Queries And the M:N Relationship
In the previous lesson, MySQL Step By Step: Queries Over Multipe Tables (JOIN), we learned
JOINs and now we
can query through multiple tables. Today, we're going to continue in this
manner. We'll create one more table for comments and then learn about the M:N
We're going to extend our content management system and create a
comment table. The comment (similarly as the article) is bound to
the user. But it's also bound to the article. That means, we have two 1:N
relationship here. One article can have N comments and also one user can have N
comments. A comment always belongs to one user and one article.
Since the comment is the part and it belongs to two wholes (to the article and the user), it'll contain 2 columns with the article id and the user id. Such columns storing the id of an entry from another table are called
...End of the preview...
ict.social is a large database made up of manuals and tutorials, whose main goal is to provide high-quality IT education to everyone. We started out in the Czech republic, where we display roughly a million articles per month and receive plenty of gratitude from our users. Thanks to our successful establishment, we are now bringing these articles to the rest of the world.
Although we are trying to keep our content free of charge, maintaining the site is a huge effort for everyone involved. Therefore, some content (exercises and more advanced material) costs network points. Don't worry, they're really cheap :)
Requested article covers this content:
In this tutorial, we'll continue to make queries through multiple MySQL tables and learn how to create the M:N relationship using an associative table.
Buying this article gives you unlimited access to it forever. You will learn some more and help us keep giving our site maintenance which helps you and others get better futures. It's a win-win.
You gain points by supporting our network. This is done by sending a helpful amount of money to support the site, or by creating content for the network.
You can get points immediately using:
|Credit card||SMS||Wire transfer|