https://gkscientist.com/wp-content/cache/breeze-minification/js/breeze_b4d3f37f12c20b842849ca0639c02896.js
https://gkscientist.com/wp-content/cache/breeze-minification/js/breeze_696423080bc3febaacae85a23cf0b2f2.js
https://gkscientist.com/wp-content/cache/breeze-minification/js/breeze_600fcb7370a6a277f0948f631972ad32.js
https://gkscientist.com/wp-content/cache/breeze-minification/js/breeze_edb7e0f40b50ed01f56f644388a7ed5c.js
https://gkscientist.com/wp-content/cache/breeze-minification/js/breeze_5ffbd24321329107621bcdd1a589c9e7.js
https://gkscientist.com/wp-content/cache/breeze-minification/js/breeze_f0d5fe332ba576f712685aee12860bd6.js
https://gkscientist.com/wp-content/cache/breeze-minification/js/breeze_a20d1929da1b9d747d7d22165a7be3dd.js
By Gk Scientist Nov 18, 2022
MySQL Sub Query with Exists and Not Exists
MySQL Sub Query:
MySQL Sub Query is a query nested within another query such as SELECT, INSERT, UPDATE or DELETE.
MySQL Sub Query with Exists and Not Exists:
When a subquery is used with the EXISTS or NOT EXISTS operator, a subquery returns a Boolean value of TRUE or FALSE.
MySQL Sub Query Syntax:
SELECT column_name (s) FROM table1 WHERE (SELECT column_name FROM table2) |
MySQL Exists Syntax:
SELECT column_name (s) FROM table1 WHERE EXISTS (SELECT column_name FROM table2) |
MySQL Not Exists Syntax:
SELECT column_name (s) FROM table1 WHERE NOT EXISTS (SELECT column_name FROM table2) |
Sample Table:
MySQL Sub Query on Sample Table:
MySQL EXISTS Operator on Sample Table:
- If cn_name (London) exists in the city table, then it will fetch all data of the field (name) contained in the student table.
MySQL NOT EXISTS Operator on Sample Table:
- If cn_name (England) not exists in the city table, then it will fetch all data of the field (name) contained in the student table.
https://gkscientist.com/wp-content/cache/breeze-minification/js/breeze_74d79f8630116443498b24677f0de1a6.js
https://gkscientist.com/wp-content/cache/breeze-minification/js/breeze_96aa70e645da775a1d7db42d88d9c946.js
https://gkscientist.com/wp-content/cache/breeze-minification/js/breeze_bea6b8a0bf5e2e5c2b61a02985e2b1d8.js
https://gkscientist.com/wp-content/cache/breeze-minification/js/breeze_c62a51f088310fab21dfec1a3b4a2876.js
https://gkscientist.com/wp-content/cache/breeze-minification/js/breeze_64d108e4c785da2e5948c374dc6b638f.js
https://gkscientist.com/wp-content/cache/breeze-minification/js/breeze_4ef95617597be33ae36a7b3f97bf2090.js
https://gkscientist.com/wp-content/cache/breeze-minification/js/breeze_77bd172e5f928c7b4507d1ad9459b591.js
https://gkscientist.com/wp-content/cache/breeze-minification/js/breeze_31aaf570c1421a61308651d923752a9c.js
https://gkscientist.com/wp-content/cache/breeze-minification/js/breeze_afbe18323531e0afaf1915efe31287df.js
https://gkscientist.com/wp-content/cache/breeze-minification/js/breeze_992c04482408e1c1d3dbb7a143eb05c0.js
https://gkscientist.com/wp-content/cache/breeze-minification/js/breeze_96aa70e645da775a1d7db42d88d9c946.js
https://gkscientist.com/wp-content/cache/breeze-minification/js/breeze_96aa70e645da775a1d7db42d88d9c946.js
Comments (No)