MySQL数据合并列转倒

结果

原数据

SELECT `id`,
	MAX(CASE
					WHEN n2='p1' THEN n1
						ELSE '0'
				END
			) AS 'p1'
	,
	MAX(CASE
					WHEN n2='p2' THEN n1
						ELSE '0'
				END
			) AS 'p2'
	,
	MAX(CASE
					WHEN n2='p3' THEN n1
						ELSE '0'
				END
			) AS 'p3'
FROM
	n_test
GROUP BY id

 

第二种

结果

SELECT *,GROUP_CONCAT(CONCAT_WS(',',n2)) FROM n_test GROUP BY id