查询姓名为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 |