mysql-行列转换

最新推荐文章于 2021-02-08 09:30:50 发布

很直的直男癌

最新推荐文章于 2021-02-08 09:30:50 发布

阅读量2.8k

点赞数

分类专栏： mysql

本文链接：https://blog.csdn.net/sddaaa/article/details/69808019

版权

mysql 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

-------注意sum函数是统计合-------

select   name,
sum(case when course='java' then grade end) as java,
sum(case when course='C++' then grade end) as C++,
sum(case when course='C#' then grade end) as C#
from test group by name

---------------------如果有字符串就单纯的转换用合并函数合一下不然group by 只显示第一条------------------------------

SELECT * FROM(SELECT `name`,
GROUP_CONCAT(CASE WHEN `key`='redis.host' THEN val END SEPARATOR ',') AS `host`,
GROUP_CONCAT(CASE WHEN `key`='redis.port' THEN val END SEPARATOR ',')AS `port`,
GROUP_CONCAT(CASE WHEN `key`='redis.database' THEN val END SEPARATOR ',')AS `database`,
GROUP_CONCAT(CASE WHEN `key`='redis.pwd' THEN val END SEPARATOR ',' )AS `pwd`

FROM `sys_game_config` WHERE `name` = 'cache-1069' )a GROUP BY `name`