MySQL Nested Example

Advertisement

MySQL Nested Select is select query, that is nested inside the select, update and delete query based on the condition specified in a Where Clause.

MySQL Nested Example

MySQL Nested Select is select query, that is nested inside the select, update
and delete query based on the condition specified in a Where Clause. The
Nested Select returns you the set of records from table based on the condition
of nested select query specified in Where Clause.

Understand with Example

The Tutorial illustrate an example from 'MySQL Nested Select'. To understand
the example we create a table 'MyTable' with given fieldnames and
datatypes specified in the below example.

The create table statement is used to create a table 'MyTable' with
required fieldnames and datatypes respectively.

The Nested select Query is used to return the empid values from table
employee. Based on the empid condition specified in Where Clause ,the select
query returns you the records details from table 'mytable'.