MySQL:如何并排显示列名和行字段值

Question

我有一个表，有130+列，需要显示它的列名和行字段值并排记录。有人能帮我用MySQL语句吗?下面的代码将有助于澄清我正在寻找的输出:

在数据库:

A   B   C   D   E <- Column Name
1   2   3   4   5 <- Value

resultset所需的输出格式:

Field - Value           
A        1          
B        2          
C        3          
D        4          
E        5

使用以下代码，我能够获得列名列表，但不知道如何获得与之相关的值:

SELECT c.column_name as qid
FROM information_schema.columns c -- this has the column names       
WHERE c.table_name = 'TABLE NAME'

提前感谢。

Answer 1

使用UNION

SELECT 'A' AS Field, A as Value
FROM tablename
UNION ALL
SELECT 'B', B
FROM tablename
UNION ALL
SELECT 'C', C
FROM tablename
UNION ALL
SELECT 'D', D
FROM tablename
UNION ALL
SELECT 'E', E
FROM tablename