Sql中查询结果为空给定默认值 Mysql: select ifnull(usenum,0) as num from user ; Orcale: select nvl(.usenum,0) as num from user ; 另外ifnull (usenum,0)函数间有空格也会产生这个问题。 原文链接:https://blog.csdn.net/weixin_43591947/article/details/103287983