Mysql 行转列，列转行

CREATE TABLE `StudentScores` (
  `UserName` varchar(20) DEFAULT NULL,
  `Subject` varchar(30) DEFAULT NULL,
  `Score` float DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO StudentScores SELECT 'Nick', '语文', 80;
INSERT INTO StudentScores SELECT 'Nick', '数学', 90;
INSERT INTO StudentScores SELECT 'Nick', '英语', 70;
INSERT INTO StudentScores SELECT 'Nick', '生物', 85;
INSERT INTO StudentScores SELECT 'Kent', '语文', 80;
INSERT INTO StudentScores SELECT 'Kent', '数学', 90;
INSERT INTO StudentScores SELECT 'Kent', '英语', 70;
INSERT INTO StudentScores SELECT 'Kent', '生物', 85;