表中3条数据:
(https://img-blog.csdn.net/20160723105506355)
SQL语句:
SELECT
table_name,
max(CASE attr
WHEN ‘name’ THEN
attr_value
ELSE
NULL
END) name,
max(CASE attr
WHEN ‘email’ THEN
attr_value
ELSE
NULL
END) email,
max(CASE attr
WHEN ‘address’ THEN
attr_value
ELSE
NULL
END) address
FROM
test
GROUP BY
table_name;
结果:
(https://img-blog.csdn.net/20160723105813569)
本人小白一枚,上述如果有错误、不恰当的地方或者有更好的方法,还望大牛们指出,谢谢!!