MySql 使用 NOT IN 返回值包含null值，返回数据不全

 

 

mysql not in() 找不到null status n in ('100','200','300','500')  换成 status in ('400') is not true

 

 

 

 

 

 

来源：https://blog.csdn.net/qq_35387940/article/details/127959272?spm=1001.2101.3001.6650.17&utm_medium=distribute.pc_relevant.none-task-blog-2%7Edefault%7EBlogCommendFromBaidu%7ERate-17-127959272-blog-120019885.235%5Ev43%5Epc_blog_bottom_relevance_base1&depth_1-utm_source=distribute.pc_relevant.none-task-blog-2%7Edefault%7EBlogCommendFromBaidu%7ERate-17-127959272-blog-120019885.235%5Ev43%5Epc_blog_bottom_relevance_base1&utm_relevant_index=24