【mysql】sum处理null的结果 





 




SELECT
    IFNULL(sum(security_code_total), 0) createSCNum,
    IFNULL(sum(print_num), 0) privateScNum
FROM
    security_code_config
WHERE
    tid = 'test_tenement_123'
AND 
    DATE_FORMAT(create_date, '%Y-%m') = DATE_FORMAT('2019-03-01 11:32:54','%Y-%m')




 


使用IFNULL(查询值，0)


 






		

		
posted @ 
2019-03-01 11:31 
Angel挤一挤 
阅读(422) 
评论(0) 
编辑 
收藏 
举报