语句有null要注意

最新推荐文章于 2023-06-24 19:08:14 发布

要搞好学习哟

最新推荐文章于 2023-06-24 19:08:14 发布

阅读量130

点赞数

分类专栏：报错记录

本文链接：https://blog.csdn.net/weixin_45841729/article/details/118465818

版权

报错记录专栏收录该内容

14 篇文章 0 订阅

订阅专栏

本文探讨了SQL查询中遇到的错误，特别是当涉及到NULL值时可能导致无结果的问题。解决方法是谨慎处理NULL，使用IS NULL条件来判断。文章通过一个具体的查询示例，展示了如何调整查询以避免空结果，对于数据库管理和后端开发人员具有指导意义。

摘要由CSDN通过智能技术生成

错误语句

select d.id              as did,
               d.deviceCode      as deviceCode,
               d.deviceName      as deviceName,
               d.deviceState     as deviceState,
               d.deviceSize      as deviceSize,
               d.deviceProfile   as deviceProfile,
               dt.deviceTypeCode as deviceTypeCode,
               dt.deviceTypeName as deviceTypeName,
               fb.factoryCode    as bfactoryCode,
               fb.factoryName    as bfactoryName,
               fb.factoryProfile as bfactoryProfile,
               fp.factoryCode    as pfactoryCode,
               fp.factoryName    as pfactoryName,
               fp.factoryProfile as pfactoryProfile,
               o.ordersCode      as ordersCode
        from device as d
                 left outer join deviceType as dt on dt.deviceTypeCode = d.deviceTypeCode
                 left outer join factory as fb on fb.factoryCode = d.factoryCodeBelong
                 left outer join factory as fp on fp.factoryCode = d.factoryCodePresent
                 left outer join orders as o on o.ordersCode = d.ordersCode
        where d.ordersCode = null and d.factoryCodePresent = '9c67175ed423c9a08122d208d352b';