MySQL 行转列 -》动态行转列 -》动态行转列带计算

Pivot Table Using MySQL - A Complete Guide | WebDevZoom
http://webdevzoom.com/pivot-table-using-mysql/

Cross-Tabulation (Pivot Tables) with MySQL - CodeProject
https://www.codeproject.com/articles/363339/cross-tabulation-pivot-tables-with-mysql

Pivot Tables in MySQL
https://codingsight.com/pivot-tables-in-mysql/

MySQL存储过程的动态行转列 - 七度尘 - SegmentFault 思否
https://segmentfault.com/a/1190000004314724

MySQL存储过程的动态行转列 - 七度尘 - SegmentFault 思否
https://segmentfault.com/a/1190000004314724

Pivot table with dynamic columns in MySQL - Stratos Blog
http://stratosprovatopoulos.com/web-development/mysql/pivot-table-with-dynamic-columns/

mysql 行转列 列转行 - 平凡希 - 博客园
https://www.cnblogs.com/xiaoxi/p/7151433.html

sql的行转列(PIVOT)与列转行(UNPIVOT) - linYongJie - 博客园
https://www.cnblogs.com/linJie1930906722/p/6036714.html

MySQL | Group_CONCAT() Function - GeeksforGeeks
https://www.geeksforgeeks.org/mysql-group_concat-function/

mysql行转列转换 - Coder_PWH - CSDN博客
https://blog.csdn.net/sinat_27406925/article/details/77507478

如何用MYSQL 做 Pivot Table? - 风随云动 之 PHP 全攻略 - CSDN博客
https://blog.csdn.net/redwood_lin/article/details/1550606

动态数据透视表pivot table(行转换列) - Edison Xu - CSDN博客
https://blog.csdn.net/xeseo/article/details/24364921

MySQL 5.7的 行格式 - zuiweng158的博客 - CSDN博客
https://blog.csdn.net/zuiweng158/article/details/53377277

mysql - Like UNPIVOT in SQL! - Database Administrators Stack Exchange
https://dba.stackexchange.com/questions/161888/like-unpivot-in-sql

原文地址:https://www.cnblogs.com/rgqancy/p/10922916.html