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

14/04
Wed
weather - icon
Snow
3°C
15/04
Thu
weather - icon
Rain
9°C
16/04
Fri
weather - icon
Clouds
9°C
17/04
Sat
weather - icon
Rain
10°C
18/04
Sun
weather - icon
Rain
7°C
19/04
Mon
weather - icon
Rain
8°C
20/04
Tue
weather - icon
Rain
8°C

Powered by OpenWeatherMap | by Phee

RSS Laracasts

  • Eloquent Updates and HTML Escaping 14/04/2021
    In this lesson, we'll briefly discuss how to go about updating database records using Eloquent. Then, we'll review an example of why escaping user-provided input is essential for the security of your application.
    Jeffrey Way
  • The Back Button Bug When Voting 13/04/2021
    In this episode, we discover and fix a bug that throws off our state in Livewire when using the back button in the browser.
    Jeffrey Way
  • Voting for Ideas 12/04/2021
    We can now tackle the actual voting functionality that allows a user to vote for any idea.
    Jeffrey Way
  • Did the Current User Vote for the Idea 09/04/2021
    Let's continue the voting functionality and add some logic to check if a given idea was voted for by the logged-in user. We'll reach for subqueries to ensure that our queries are optimized and not at risk of the "n+1" issue.
    Jeffrey Way
  • Make a Post Model and Migration 08/04/2021
    Now that you're a bit more familiar with migration classes and Eloquent models, let's apply this learning to our blog project. We'll remove the old file-based implementation from the previous chapter, and replace it with a brand new Post Eloquent model. We'll also prepare a migration to build up the posts table.
    Jeffrey Way

Latest Tweets

  • @Pasjisin Kakav click-bait post na tviteru u stilu blica, informera i slicnih 😂
    2 weeks ago
  • @WhistlerDick Eto, voleli ne voleli Ronalda, on i kad napravi sranje odradi pravu stvar.
    2 weeks ago
  • @DarkoBoomShake Da ne radis u banci mozda na kreditima? 🤓
    4 weeks ago