DEV Community

Cover image for Day 99 of 100 Days of Code & Scrum: Relationships Between Tables, Various JOIN Types in MySQL
Rammina
Rammina

Posted on • Originally published at blog.rammina.com

Day 99 of 100 Days of Code & Scrum: Relationships Between Tables, Various JOIN Types in MySQL

❤️ Happy Valentine's Day, everyone! ❤️

I love coding, so it's my Valentine, and I have been doing just that the entire day. Jokes aside, I took a relatively easy day today, spending time with my loved ones and having a bit of fun. Coding may be enjoyable, but I didn't want to grind all day on a special occasion.

Moving on, I reviewed various types of table relationships and the different types of JOINs, just so that I have a clearer understanding of them. Honestly, it's going to take me some time to intuitively understand when to use one over the others, but I suppose I should just practice more.

Anyway, let's move on to my daily report!

Yesterday

Grinded real hard learning about more complex data types, DATETIME utility functions, and logical operators in MySQL.

Today

MySQL

  • practiced using SQL JOIN to generate meaningful data by combining multiple relational tables.
  • reviewed the different types of JOINs:
    • INNER JOIN - INNER JOIN keyword selects all rows from both the tables as long as the condition is satisfied.
    • LEFT JOIN - returns all the rows of the table on the left side of the JOIN and matching rows for the table on the right side of JOIN.
    • RIGHT JOIN - returns all the rows of the table on the right side of the JOIN and matching rows for the table on the left side of JOIN.
    • FULL JOIN - creates the result-set by combining result of both LEFT JOIN and RIGHT JOIN. The result-set will contain all the rows from both the tables.
  • continued Colt Steele's MySQL course.

Scrum

Thank you for reading! Have a good day!

Rammina Thank You Banner

Resources/Recommended Readings

DISCLAIMER

This is not a guide, it is just me sharing my experiences and learnings. This post only expresses my thoughts and opinions (based on my limited knowledge) and is in no way a substitute for actual references. If I ever make a mistake or if you disagree, I would appreciate corrections in the comments!


Other Media

Feel free to reach out to me in other media!

Rammina Logo

Twitter logo

Github logo

Top comments (2)

Collapse
 
darito profile image
David Alonso

Happy Valentine's Day!

Collapse
 
rammina profile image
Rammina

Happy Valentine's Day to you as well!