This is a pivot table given your example: SELECT MAX(CASE `key` WHEN 'key1' THEN `value` END) AS `key1`, MAX(CASE `key` WHEN 'key2' THEN ...
確定! 回上一頁