此篇博客介绍了如何使用MySQL将多个表的attend_day数据通过UNION ALL操作合并，并进行行列转换，以方便数据分析。作者展示了如何利用SQL查询技巧实现数据类型转换和结构统一。
原表：
转换sql：
select attend_id,attend_name,'attend_day1' as attend_day, ka.attend_day1 as attend_type from krs_attendance ka
union all
select attend_id,attend_name,'attend_day2' as attend_day, ka.attend_day2 as attend_type from krs_attendance ka
union all
select attend_id,attend_name,'attend_day3' as attend_day, ka.attend_day3 as attend_type from krs_attendance ka 
扫一扫
667
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
