在mysql中使用列值作为另一列的标题

-- 创建示例表
CREATE TABLE example_table (
  id INT PRIMARY KEY,
  column_title VARCHAR(50),
  column_data VARCHAR(50)
);

-- 插入示例数据
INSERT INTO example_table (id, column_title, column_data)
VALUES (1, 'Title1', 'Data1'),
       (2, 'Title2', 'Data2'),
       (3, 'Title3', 'Data3');

-- 使用动态SQL语句查询并将列值作为标题
SET @sql = '';
SELECT GROUP_CONCAT(DISTINCT
           CONCAT('MAX(CASE WHEN column_title = "', column_title, '" THEN column_data ELSE NULL END) AS "', column_title, '"')
         ) INTO @sql
FROM example_table;

SET @sql = CONCAT('SELECT ', @sql, ' FROM example_table');

-- 执行动态SQL语句并获取结果
PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;