SQL---空字符串不等于null

查询没有写家庭住址的同学

SELECT studentname FROM student

WHERE Address IS NULL;

空字符串不等于null，所以输入的是空字符串，仍然可以查到

正确做法

SELECT studentname FROM student

WHERE Address=’’ OR Address IS NULL;