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
相关文章
- 03-07Mybatis plus 报Null return value from advice does not match primitive return type for错误
- 03-07attempted to return null from a method with a primitive return type
- 03-07insertSale attempted to return null from a method with a primitive return type (int).
- 03-07mysql查询null异常:attempted to return null from a method with a primitive return type
- 03-07org.apache.ibatis.binding.BindingException: Mapper method 'attempted to return null from a method with a primitive return type (long).
- 03-07attempted to return null from a method with a primitive return type (int).
- 03-07Mapper method 'com.xxxx.other.dao.MyDao.getNo attempted to return null from a method with a primitive return type (int)
- 03-07delete attempted to return null from a method with a primitive return type (int)
- 03-07rg.apache.ibatis.binding.BindingException: Mapper method 'com.dao.Cameao.getOnlineDayRation attempted to return null from a method with a primitive return type (float)
- 03-07Mapper method 'com.xxxx.other.dao.MyDao.getNo attempted to return null from a method with a primitive return type (int)