56,681
社区成员
发帖
与我相关
我的任务
分享
BEGIN
drop table if exists temptable1;
Set @sq1=CONCAT('Create table temptable1(',sqlstr,')');
PREPARE stmt1 FROM @sq1;
EXECUTE stmt1;
DEALLOCATE PREPARE stmt1;
SET @EE='';
SELECT
GROUP_CONCAT(DISTINCT
CONCAT(
'SUM(IF(b.', columnname ,' = ''',CallType,''', b.',rowname,', 0)) AS ''', CallType, '''')
) into @EE
FROM temptable1 c;
select @EE;
-- SELECT
-- GROUP_CONCAT(DISTINCT
-- CONCAT(
-- 'SUM(IF(b.''',columnname,''' = ''',
-- c.CallType,
-- ''', b.cc, 0)) AS ''',
-- c.CallType, ''''
-- )
-- ) into @EE
-- FROM reportcall c;
SET @QQ = CONCAT('select ',@EE,' from temptable1 b ',sort );
SELECT @QQ;
PREPARE stmt FROM @QQ;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
END