《Mysql學習mysql 將列值轉變為列的方法》要點：
本文介紹了Mysql學習mysql 將列值轉變為列的方法，希望對您有用。如果有疑問，可以聯系我們。

-- 創建庫
CREATE TABLE `rate` (
?`uname` VARCHAR (300),
?`object` VARCHAR (300),
?`score` VARCHAR (300)
);

MYSQL入門-- 插入數據
INSERT INTO test.rate (uname, object, score)
?VALUES('aaa', 'chinese', '67'),
?('aaa', 'math', '89'),
?('aaa', 'physical', '89'),
?('bbb', 'chinese', '67'),
?('bbb', 'math', '75'),
?('bbb', 'physical', '89');

MYSQL入門
-- 查詢
SELECT DISTINCT uname AS '姓名',
SUM(CASE object
WHEN 'chinese' THEN score END)? AS '語文',
SUM(CASE object
WHEN 'math' THEN score END)? AS '數學',
SUM(CASE object
WHEN 'physical' THEN score END)? AS '物理' FROM rate GROUP BY uname;

轉載請注明本頁網址：
http://www.fzlkiss.com/jiaocheng/2421.html