What is the use of subqueries in mysql

Question

how does it helps to query optimisation

Answer 1

Hope this helps:
http://www.mysqltutorial.org/mysql-subquery/

Answer 2

thanks dayve...

Answer 3

you can use your query string for another query
design it by using the inner query

Answer 4

Subquery is a query embedded in another query. For example- using 'where' in a 'select' or 'insert' query.