zhaoqian199529的博客

select A.date_range,`USER`,A.USER_ID,A.PROJECT,`GROUP`, sum(IF(A.staus='pushed to',A.ct, 0)) as `pushed to`, sum(IF(A.staus='pushed new',A.ct,0)) as `pushed new`, sum(IF(A.staus='created',A.ct,0)) as `created`, sum(IF(A.staus='deleted',A.ct,0)) as `delete.

这里是引用 https://stackoverflow.com/questions/12598120/mysql-pivot-table-query-with-dynamic-columns