mysql结果集合切换 - mysql数据库栏目 - 自学php

结果集A:

转换成为结果集B:

mysql中实现如下:

SELECT a.biz_date, CASE WHEN a.`event` = 'downClick' THEN a.uv END AS downClick, CASE WHEN a.`event` = 'successClick' THEN a.uv END AS successClick, CASE WHEN a.`event` = 'installSuccess' THEN a.uv END AS installSuccess from a

查看更多关于mysql结果集合切换 - mysql数据库栏目 - 自学php的详细内容...