初始數據:

CREATE TABLE `TEST_TB_GRADE` (`ID` int(10) NOT NULL AUTO_INCREMENT,`USER_NAME` varchar(20) DEFAULT NULL,`COURSE` varchar(20) DEFAULT NULL,`SCORE` float DEFAULT '0',PRIMARY KEY (`ID`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;insert into TEST_TB_GRADE(USER_NAME, COURSE, SCORE) values ("張三", "數學", 34), ("張三", "語文", 58), ("張三", "英語", 58), ("李四", "數學", 45), ("李四", "語文", 87), ("李四", "英語", 45), ("王五", "數學", 76), ("王五", "語文", 34), ("王五", "英語", 89); select user_name, '語文' COURSE , CN_SCORE as SCORE from test_tb_grade2 union select user_name, '數學' COURSE, MATH_SCORE as SCORE from test_tb_grade2 union select user_name, '英語' COURSE, EN_SCORE as SCORE from test_tb_grade2 order by user_name,COURSE;

總結

以上是生活随笔為你收集整理的MySQL列转行sql语句的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。