where isnull
时间: 2023-09-03 16:14:21 浏览: 56
在查询语句中,"is null"用于查询指定字段为null的数据。它的作用是筛选出指定字段值为空的记录。例如,在一个表中,如果我们想查询某个字段的值为null的记录,可以使用"where 字段名 is null"的语法。这将返回字段值为null的记录。这将返回指定字段值不为空的记录。<em>1</em><em>2</em><em>3</em>
#### 引用[.reference_title]
- *1* [MySQL where条件is null 及is not null 的用法](https://blog.csdn.net/zzx262625/article/details/129295457)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT3_1"}} ] [.reference_item]
- *2* [Mysql where条件中IS NULL 是否走索引?](https://blog.csdn.net/chenqiushi123/article/details/109857166)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT3_1"}} ] [.reference_item]
- *3* [MySQL LEFT JOIN (where is null 否定 on里面条件)](https://blog.csdn.net/yfgcq/article/details/11128815)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT3_1"}} ] [.reference_item]
[ .reference_list ]