Mysql subquery is a nested query  that is being used inside another queries like select, update, delete etc. A mysql subquery also called a inner query and the