语法:
- is null
select * from 表名 where 字段名 is null;
- ISNULL()
select * from 表名 where ISNULL(字段名);
- 比较区别
我的数据库表的数据量(146671条)
- 执行sql
select * from fts_srv_dtr_f where ISNULL(BRANCH_NAME);
select * from fts_srv_dtr_f where BRANCH_NAME is null;
- 执行结果(is null比isnull()稍微快一点)