mysql实现行转列的方法：1、用cross join的方式实现，代码为【cross join(select sum(a.kills) '猪八戒】；2、用case语句的方式实现，代码为【case when user_name='孙悟空'】。
mysql实现行转列的方法：
1、用cross join的方式实现
select * from
(select sum(a.kills) '孙悟空'
from kills1 as a
LEFT JOIN tssrz as b
on a.user_id = b.id
WHERE b.user_name = '孙悟空'
GROUP BY b.user<i style="color:transparent">本文来源gaodai$ma#com搞$代*码*网(</i>_name) e
cross join
(select sum(a.kills) '猪八戒'
from kills1 as a
LEFT JOIN tssrz as b
on a.user_id = b.id
WHERE b.user_name = '猪八戒'
GROUP BY b.user_name) f
2、用case语句的方式实现
SELECT sum(case when user_name='孙悟空' then kills end) as '孙悟空',
sum(case when user_name='猪八戒' then kills END) as '猪八戒',
sum(case when user_name='沙和尚' then kills END) as '沙和尚'
from tssrz as a
join kills1 as b
on a.id = b.user_id
相关免费学习推荐：mysql视频教程
以上就是mysql如何实现行转列的详细内容，更多请关注搞代码gaodaima其它相关文章！
搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：mysql如何实现行转列
转载请注明原文链接：mysql如何实现行转列
