mysql 行转列

SET @SQL = NULL;


SELECT
GROUP_CONCAT(
DISTINCT CONCAT(
'MAX(IF(a.code = ''',
CODE,
''',a.rejectQuantity, 0)) AS ''',
CONCAT(mm, '/', dd),
''''
)
) INTO @SQL
FROM
reject;




SET @SQL = CONCAT(
'Select b.*,',
@SQL,
' From reject a
right join bom b
on a.code = b.code
            Group by dd'
);


PREPARE stmt
FROM
@SQL;


EXECUTE stmt;


DEALLOCATE PREPARE stmt;