Incorrect parameters in the call to native function 'iFnull'

原创于 2019-11-06 14:57:55 发布 · 1.4w 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mysql

数据库记录系列专栏收录该内容

7 篇文章

订阅专栏

本文详细解析了一段SQL代码中出现的括号缺失错误，并提供了正确的代码示例。通过对比错误和正确的代码，读者可以理解SQL语法中括号使用的重要性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

错误代码

select ROUND(IFNULL(sum(shc.price) /(select sales_area from scheme_house_type_rel where id = '61e270639e46441b90f372bf7d0d2d7f'),0),2) as hardCoverPrice
    from scheme_scheme ss
    LEFT JOIN scheme_hard_cover shc on shc.scheme_id = ss.id and shc.state = 1
    LEFT JOIN scheme_house_type_rel shtr on shtr.scheme_id = ss.id
    where ss.state !=0 and ss.id = 'd08e4f9ed36d419eb1cf7481155ec9e8'

原因分析：少了个括号，哈哈哈哈，一定要仔细看清楚了

正确代码

 select ROUND(IFNULL((sum(shc.price) /(select sales_area from scheme_house_type_rel where id = '61e270639e46441b90f372bf7d0d2d7f')),0),2) as hardCoverPrice
    from scheme_scheme ss
    LEFT JOIN scheme_hard_cover shc on shc.scheme_id = ss.id and shc.state = 1
    LEFT JOIN scheme_house_type_rel shtr on shtr.scheme_id = ss.id
    where ss.state !=0 and ss.id = 'd08e4f9ed36d419eb1cf7481155ec9e8'