Also, a subquery can be nested within another subquery.Ī MySQL subquery is called an inner query while the query that contains the subquery is called an outer query. Introduction to the MySQL SubqueryĪ MySQL subquery is a query nested within another query such as SELECT, INSERT, UPDATEor DELETE. Summary: in this tutorial, we will show you how to use the MySQL subquery to write complex queries and explain the correlated subquery concept.
