mysql中将null值转换为0的语句_MySQL
来源：动视网
责编：小采
时间：2020-11-09 19:03:15
mysql中将null值转换为0的语句_MySQL
mysql中将null值转换为0的语句_MySQL:bitsCN.com 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=23331401bitsCN.com
导读mysql中将null值转换为0的语句_MySQL:bitsCN.com 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=23331401bitsCN.com
bitsCN.com
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
bitsCN.com
mysql中将null值转换为0的语句_MySQL
mysql中将null值转换为0的语句_MySQL:bitsCN.com 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=23331401bitsCN.com
