Learning MySQL - SubQueries

This tutorial covers how to use additional queries as part of your WHERE clause filter.

[maxtayebwa]

And I made it... Just received an offer. Thanks once again prof.

[maxtayebwa]

Awesome, my Prof. The other day you gave me tips on how to prepare for intermediate JS interview. I did the interview last Friday and boom, everything you said was spot on. I didn't feel disappointed in the way I answered at all. Am now waiting for feedback. But thanks so very much! I have recommended to my friends to watch your videos and subscribe to this channel. Blessings!

[saccamadiqeu]

0:03 by hearing you say just this one word, and I knew you're Canadian

[cyberflow]

You've solved a couple of troubles I really had on my project. Thank you, Steve.

[aeaeaeae]

Very well explained! I just needed to understand the basics, so now I can write more complex stuff. Thank you very much!

[mathiasweichert]

Thank you for sharing your knowledge with everyone!

[jackb]

Steve your videos are great, I always come back to them (like an ex girlfriend!)

[matyilagoodwish]

Thanks, this is very well explained somewhat found it harder to explain to someone so I just sent a link of this video.

[TK-mfdz]

Hi Steve, good explanation but qq: based on your example, how would you update your querry to see there in one line not genre_id, but the id itself like "Fantasy", etc?

[florianvo]

We just had subqueries in vocational school and we never used the keyword "In". We learned that you should always combine subqueries with a join and make a clear connection for the Keys, to avoid cartesian product. Also when you have an aggregating function or smth in your query, would the query from the video still work? Im not sure tho

[Lennings]

in my wordpress database the data is saved in one key and one column. is it a way to get my data in column to row format?
or should i make a table that saves the column id in a row

[clarencechong]

Let's say if you want to combine 3 tables together using subquery, how would you do that?

[janlawrence]

Hi sir can you help me to convert join into subquery?

[superfreiheit]

Good explaination but I do not understand what benefit there are to use it