我使用mysql建立动态字段交叉表查询如下:
set @sql = (
select Group_concat(distinct
concat(
"sum(case when `ContentDetail_ID`='", ContentDetail_ID, "' then `Result` end) as `", `ContentDetail_ID`, "`"
)
)
from QA_Detail_Table
);
SET @sql = CONCAT('SELECT Project_ID,Content_ID,Category_1,Category_2,Category_3,',@sql,'
FROM QA_Detail_Table
GROUP BY Project_ID,Content_ID,Category_1,Category_2,Category_3');
PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
但是不能生成视图,请问如何使用查询呢?
|