数据库行列转换
原表
转换之后
代码
SELECT f,province,city,area,
SUM(CASE `t` WHEN 201201 THEN price ELSE 0 END) AS '201201',
SUM(CASE `t` WHEN 201202</
数据库行列转换
原表
转换之后
代码
SELECT f,province,city,area,
SUM(CASE `t` WHEN 201201 THEN price ELSE 0 END) AS '201201',
SUM(CASE `t` WHEN 201202</