php - 具有多个计数的 MySQL 数据透视表

Question

这是我的 MySQL 表的快照:

是否可以编写一个查询来获得像输出这样的数据透视表...

Answer 1

怎么样

SELECT url_host,
    SUM(CASE WHEN post_id = -1 THEN 1 ELSE 0 END) as post_id_minus1,
    SUM(CASE WHEN post_id = 0 THEN 1 ELSE 0 END) as post_id_0,
    etc...
FROM    YOUR_TABLE
GROUP BY url_host