SQL基础（一三）--- 空值检测

查询姓名为NULL的员工信息：

错误查询：

mysql> select * from t_employee
    -> where fname=null;
Empty set

正确查询：

mysql> select * from t_employee
    -> where fname is null;
+---------+-------+------+---------+
| fnumber | fname | fage | fsalary |
+---------+-------+------+---------+
| IT002   | NULL  |   27 | 2800    |
+---------+-------+------+---------+
1 row in set

查询姓名非空值的员工信息：

mysql> select * from t_employee
    -> where fname is not null;
+----------+-------+------+---------+
| fnumber  | fname | fage | fsalary |
+----------+-------+------+---------+
| DEV001   | Tom   |   25 | 8300    |
| DEV002   | Jerry |   28 |