mysql结果集合切换_MySQL
来源：动视网
责编：小采
时间：2020-11-09 19:42:22
mysql结果集合切换_MySQL
mysql结果集合切换_MySQL:结果集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
导读mysql结果集合切换_MySQL:结果集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
结果集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
mysql结果集合切换_MySQL:结果集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
