实现附带sql:SELECTSUBSTRING(AddDateTime,1,8)ASdatatime,IF(market="shenai_wdj",COUNT(1),0)ASwdj,IF(market="shenai_xm",COUNT(1),0)ASxm,IF(market="shenai_baidu",COUNT(1),0)...
实现
附带sql:
SELECT
SUBSTRING(AddDateTime, 1, 8) AS datatime,
IF (
market = "shenai_wdj",
COUNT(1),
0
) AS wdj,
IF (
market = "shenai_xm",
COUNT(1),
0
) AS xm,
IF (
market = "shenai_baidu",
COUNT(1),
0
) AS baidu,
IF (
market = "shenai_anzhi",
COUNT(1),
0
) AS anzhi,
IF (
market = "shenai_anzhuo",
COUNT(1),
0
) AS anzhuo,
IF (
market = "shenai_tbt",
COUNT(1),
0
) AS tbt,
IF (
market = "shenai_jf",
COUNT(1),
0
) AS jf,
IF (
market = "shenai_360",
COUNT(1),
0
) AS sll,
IF (
market = "shenai_yyh",
COUNT(1),
0
) AS yyh,
IF (
market = "shenai_zs",
COUNT(1),
0
) AS zs,
IF (
market = "shenai_qq",
COUNT(1),
0
) AS qqkf,
IF (market = "home", count(1), 0) AS home
FROM
master_user
GROUP BY
SUBSTRING(AddDateTime, 1, 8),market
ORDER BY
SUBSTRING(AddDateTime, 1, 8) DESC
展开