SQL JOIN methods

  08/01/2015

I crawled the internet (read stackoverflow) many times to understand how actually each MySQL JOIN method works. There’s lot of brief and detailed explanations available if you google it, but this one i found seems descriptive and visual more than any other. Read the full article:

Weather Forecast – Belgrade

21/08
Wed
weather - icon
Clouds
24°C
22/08
Thu
weather - icon
Clouds
26°C
23/08
Fri
weather - icon
Clear
29°C
24/08
Sat
weather - icon
Clear
34°C
25/08
Sun
weather - icon
Rain
29°C
26/08
Mon
weather - icon
Rain
29°C
27/08
Tue
weather - icon
Clouds
31°C

Powered by OpenWeatherMap | by Phee

RSS Laracasts

  • Use Unique Keys to Avoid Duplication 20/08/2019
    There's one issue that we didn't address in the previous episode on many-to-many relationships. Currently, there's nothing keeping us from creating multiple records with identical post_id and tag_id combinations. Let's apply a UNIQUE index to solve this problem.
    Jeffrey Way
  • Many-to-Many 19/08/2019
    Many-to-many is one of the more confusing relationships to understand - at least initially. The most common example consists of posts and tags. Notice that any one post may have multiple tags, and any one tag may be associated with multiple posts. In situations such as this, a connection may be created between the two […]
    Jeffrey Way
  • One-to-Many 16/08/2019
    A one-to-many relationship is the second easiest to understand. A user may have many posts. A post may have many comments. A team may have many members. In each of these examples, a single record is related to any number of related records from a related table.
    Jeffrey Way
  • One-to-One 16/08/2019
    A "one-to-one" database relationship is incredibly simple to understand. If you can say that a single record from one table is related to a single record from another table, in both directions, then you have a one-to-one relationship. Here are a few examples to get you started: "A person has one social security number." "A […]
    Jeffrey Way
  • Filtering Aggregated Data 13/08/2019
    Here's another question we might ask: "Which movies have been the most profitable?" Once we solve this riddle, we can then answer a second question based on that information: "Of those results, which movies have made at least $200?"
    Jeffrey Way

Contact