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;
mysql中行变列
最新推荐文章于 2024-09-20 21:26:51 发布