如何在mysql查询中使用交叉表或pivote来动态获取月份名称？

SELECT
  t.id,
  t.name,
  MAX(CASE WHEN MONTH(t.date) = 1 THEN t.value END) AS January,
  MAX(CASE WHEN MONTH(t.date) = 2 THEN t.value END) AS February,
  MAX(CASE WHEN MONTH(t.date) = 3 THEN t.value END) AS March,
  -- 继续添加其他月份的列
FROM
  your_table t
GROUP BY
  t.id, t.name;

DELIMITER //

CREATE PROCEDURE dynamic_pivot()
BEGIN
  DECLARE sql_query VARCHAR(4000);
  DECLARE month_list VARCHAR(4000);
  DECLARE month_name VARCHAR(20);
  DECLARE month_index INT DEFAULT 1;
  
  SET month_list = '';
  
  -- 生成月份列表
  WHILE month_index <= 12 DO
    SET month_name = MONTHNAME(CONCAT('2000-', LPAD(month_index, 2, '00'), '-01'));
    SET month_list = CONCAT(month_list, ', MAX(CASE WHEN MONTH(t.date) = ', month_index, ' THEN t.value END) AS ', month_name);
    SET month_index = month_index + 1;
  END WHILE;
  
  -- 构建动态查询语句
  SET sql_query = CONCAT('SELECT t.id, t.name', month_list, ' FROM your_table t GROUP BY t.id, t.name');
  
  -- 执行查询语句
  PREPARE stmt FROM sql_query;
  EXECUTE stmt;
  DEALLOCATE PREPARE stmt;
END //

DELIMITER ;