mysql中将null值转换为0的语句

网络编程 mysql中将null值转换为0的语句 06-21


SELECT 
IF(AVG(cai.conversionsRate) IS NULL,0,AVG(cai.conversionsRate)) 
AS conversionsRate 
FROM campaign_info cai 
WHERE insertTime BETWEEN '2011-02-01' AND '2011-02-04' AND googleCampaignId=23331401

编辑：广州葆元健康生物科技有限公司

标签：googleCampaignId,insertTime,campaign_info,NULL,conversionsRate