如何将存储过程转换为单个SQL语句

Question

我的数据库中有一个表，它看起来像（表中可以有相同的元组）：

+-------------+---------+--------+
| ProductName | Status  | Branch |
+-------------+---------+--------+
| P1          | dead    |      1 |
| P1          | dead    |      2 |
| P1          | dead    |      2 |
| P2          | expired |      1 |
+-------------+---------+--------+

我必须在as（Branch属性是动态的）后面显示结果：

+-------------+---------+--------+
| ProductName | Branch 1|Branch 2|
+-------------+---------+--------+
| P1          | dead    |    dead|
| P2          | expired |     OK |
+-------------+---------+--------+

    SET @sql = NULL;
    SELECT
    GROUP_CONCAT(DISTINCT
       CONCAT(
       'COALESCE(GROUP_CONCAT(DISTINCT case when branch = ''',
       branch,
       ''' then  status  end),''OK'') AS ',
       CONCAT('Branch',branch)
       )
    ) INTO @sql
    FROM Table1;

    SET @sql = CONCAT('SELECT productName, ', @sql, ' 
    FROM Table1 
    GROUP BY productName');

    PREPARE stmt FROM @sql;
    EXECUTE stmt;
    

+-------------+---------+-----------+
| productName | Branch1 |  Branch2  |
+-------------+---------+-----------+
| p1          | dead    |    dead   |
| p2          | expired |    OK     |
+-------------+---------+-----------+

我希望将此过程转换为单个SQL语句。我试过了，但找不到解决办法。我怎样才能做到这一点呢？谢谢

Answer 1

这个确切的结果（因为它是由存储过程产生的，在运行时确定列数）不能在单个SQL select语句中再现。这不可能.