1. not in的结果集中出现null则查询结果为null;
例如下面sql中,含有list中null值,无法正确查询结果;
SELECT COUNT(name) FROM CVE WHERE name NOT IN ('CVE-1999-0001', 'CVE-1999-0002', NULL);
- in结果集有null不影响;
参考:https://blog.csdn.net/menghuanzhiming/article/details/77574135
2022-10-28 22:17:00
1. not in的结果集中出现null则查询结果为null;
例如下面sql中,含有list中null值,无法正确查询结果;
SELECT COUNT(name) FROM CVE WHERE name NOT IN ('CVE-1999-0001', 'CVE-1999-0002', NULL);
参考:https://blog.csdn.net/menghuanzhiming/article/details/77574135