Lesson 10 - MySQL Step By Step: Subqueries
In the previous lesson, MySQL Step By Step: Exercises to practise, we practiced queries on several examples. Today's lesson is all about subqueries, so it's going to complete our knowledge of the SQL basics.
A subquery is a query that's part of another query. Right, we can nest queries into another. Like this, we can use the output of one query as an input for another query because it's basically also a data table. In practice, this is widely used, and we have the ability to get all the results straight from the database that we'd otherwise have to put together in our application.
Of course, subqueries are performance-intensive, but if they're optimized
properly (see the next lessons) they should be faster than using multiple
separate queries or
Try to think about how'd you list articles of the user whose nickname is "David". You might think of the following query:
...End of the preview...
ict.social is a large database made up of manuals and tutorials, whose main goal is to provide high-quality IT education to everyone. We started out in the Czech republic, where we display roughly a million articles per month and receive plenty of gratitude from our users. Thanks to our successful establishment, we are now bringing these articles to the rest of the world.
Although we are trying to keep our content free of charge, maintaining the site is a huge effort for everyone involved. Therefore, some content (exercises and more advanced material) costs network points. Don't worry, they're really cheap :)
Requested article covers this content:
In this tutorial, we'll learn to use subqueries, nested queries in MySQL database. We'll explain new operators: IN, ALL, ANY, and EXISTS.
Buying this article gives you unlimited access to it forever. You will learn some more and help us keep giving our site maintenance which helps you and others get better futures. It's a win-win.
You gain points 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.
You can get points immediately using:
|Credit card||SMS||Wire transfer|