attempted to return null from a method with a primitive return type

select sum(deposit_amount)
from tb_commission_ib_day

mysql查询时报异常:

attempted to return null from a method with a primitive return type

是因为查询时结果是 null, 需要给默认值

select IFNULL(sum(deposit_amount),0)
from tb_commission_ib_day

 

上一篇:mysql--容器无法启动


下一篇:plus app 的缓存 storage