mysql--------not in

1.select count(*)  from vod_cloud_path v where special_path is not null and vod_id not in(select distinct vodId from cdn_cloudstroage_response where vodId is not null); 

结果不为0

2. select count(*)  from vod_cloud_path v where special_path is not null and vod_id not in(select distinct vodId from cdn_cloudstroage_response); 

结果为

 

not in的结果集中出现null则查询结果为null; 

如果是in结果集有null不影响；