Mysql行列转换

Question

我正在对我的 sql 进行查询，其中有查询:

SELECT particulars.particularName as name, particulars.Date as date, SUM(particulars.Total) as Total 
FROM particulars 
WHERE particulars.Date BETWEEN '2017-04-01' AND '2017-04-30' 
    AND particulars.Branch_BranchId='1'
GROUP by particulars.particularName,particulars.Date

输出的形式为::

但我需要以下格式的输出:

Answer 1

您需要的称为旋转。

看看这个例子(你可以在网上找到很多):

http://stratosprovatopoulos.com/web-development/mysql/pivot-a-table-in-mysql/