In MySQL, NOT EXISTS operator allows you to check non existence of any record in a subquery. The NOT EXISTS operator return true if the subquery returns zero row. The NOT EXISTS operator can be used in a SELECT, INSERT, UPDATE, or DELETE statement.
To check non existence of any record in a subquery, use the following syntax:
tablename: The table name from which you want to perform
NOT EXISTS operator.
subquery: Usually a SELECT statement starts with SELECT * or column name. MySQL ignores the SELECT list from subquery.
NOT EXISTSoperator is uses the MySQL
In the above example, the
NOT EXISTS operator will return all records from the "tblbankdemataccountcharges" table where there is no record in the tblbankheadquartersandaddress table with the matching "bankId".
You can use MySQL Command Line Client to use
NOT EXISTS operator in subquery. It will look like this: