/* 016 IS NULL & IS NOT NULL ( if value is equal to = NULL ) */ -- Create table CREATE TABLE persons( id INT NOT NULL UNIQUE, name VARCHAR(50), birth_date DATE ); -- insert records INSERT INTO persons(id,name,birth_date) VALUES (1,"Ram","1995-02-10"), (2,"Madan","1995-11-03"), (3,"Salman","1996-06-12"), (4,"Shoiab","1995-04-21"), (5,"juhi","1996-09-25"), (6,"Raman",NULL), (7,NULL,"1996-08-10"); SELECT * FROM persons WHERE birth_date IS NULL; -- it doesnot means empty SELECT * FROM persons WHERE name IS NULL; SELECT * FROM persons WHERE name IS NOT NULL;