What is the difference between IS NULL & IS NOT NULL?

1.	What is the difference between IS NULL & IS NOT NULL?
Answer» IS NULL checks to see if the cell is empty but IS NOT NULL checks to see if the cell is not empty. Example : SELECT id FROM USERS WHERE 'user_type' IS NOT NULL; SELECT id FROM users WHERE 'user_type' NOT IS NULL; NOTE: This is very ESSENTIAL MYSQL query interview questions.

Answer»

IS NULL checks to see if the cell is empty but IS NOT NULL checks to see if the cell is not empty.

Example :

SELECT id FROM USERS WHERE 'user_type' IS NOT NULL;

SELECT id FROM users WHERE 'user_type' NOT IS NULL;

NOTE: This is very ESSENTIAL MYSQL query interview questions.

Discussion