MySQL COUNT SUM

最新推荐文章于 2024-09-12 01:15:37 发布

sun488939

最新推荐文章于 2024-09-12 01:15:37 发布

阅读量2.9k

点赞数 1

文章标签： mysql null table

本文链接：https://blog.csdn.net/sun488939/article/details/5560920

版权

select count(*) as mcount , left(create_time,10) as ptime , count(if(receive_msg is null,id,null)) as nullcount , count(if(receive_msg = '1',receive_msg,null)) as apfcount , count(if(receive_msg = '2',receive_msg,null)) as dttcount , count(if(receive_msg = '3',receive_msg,null)) as dicount from t_votes where left(create_time,7)>='$pearly' and left(create_time,7)<='$plate' group by ptime ;

COUNT(*)带上值为NULL的

COUNT(table_name)不带值为NULL的

计数不求和,可用其他字段替代

select count(*) as mcount , left(create_time,10) as ptime , SUM(if(receive_msg is null,id,0)) as nullcount , SUM(if(receive_msg = '1',receive_msg,0)) as apfcount , SUM(if(receive_msg = '2',receive_msg,0)) as dttcount , SUM(if(receive_msg = '3',receive_msg,0)) as dicount from t_votes where left(create_time,7)>='$pearly' and left(create_time,7)<='$plate' group by ptime ;

SUM求和,最后一个参数改为0.具体原因不明