set @sql=null;
SELECT
GROUP_CONCAT(DISTINCT
CONCAT(
'SUM(CASE t.type WHEN ''',
t.type,'''',
' THEN t.id ',' else 0 END ) ',t.type
)
) INTO @sql
FROM test1 t;
set @sql =CONCAT('SELECT ',@sql,' from test1 t');
PREPARE stmt from @sql;
EXECUTE stmt;
转载请注明原文地址: https://www.6miu.com/read-16843.html
