Black Friday is here! Take advantage of this unique opportunity and get up to 80% extra knowledge for free! Read more here
bf extended_2022

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 relationship.

Comment table

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...
Continue further

You will gain knowledge worth hundreds of thousands for a few crowns

You've come here and that's great! We believe that the first lessons showed you something new and useful
Do you want to continue the course? Go to the premium section.

Limited offer: Learn all knowledge and save money

Buy lessons and exercise submitting one by one $4.50
Buy all currently available lessons with exercise submitting and other features for an exclusive price $3.87
Currently, you have $0
By buying this exclusive package, you'll have access to all 13 lessons in this course including exercise submitting while saving $0.63. This offer is limited for the first lessons only with an additional exclusive 15% discount.

Warning, by buying just this lesson you'll lose the limited 15% discount for the package of all the lessons.

Buy only the lesson $0.90
Currently, you have $0

This article is licensed: Premium, by buying this article, you agree with the terms of use.

What will you get from us in the next lessons?
  • Unlimited and permanent access to individual lessons.
  • High quality IT knowledge.
  • Skills to help you get your dream and well-paid job.

Article description

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.

You gain credits 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.

Article has been written for you by David Capka
Avatar
The author is a programmer, who likes web technologies and being the lead/chief article writer at ICT.social. He shares his knowledge with the community and is always looking to improve. He believes that anyone can do what they set their mind to.
Unicorn university David learned IT at the Unicorn University - a prestigious college providing education on IT and economics.
Activities