MySQL 的 列转行 小示例

不管我们在平时的学习或工作中，难免会遇到列转行的数据操作，比如下面的这个例子:

1、先建立我们的测试表

drop table if exists stu_Score; create table stu_Score(name varchar(10),Java int,`C#` int,Python int);

2、插入测试数据

insert into stu_Score values('Dina',82,93,90); insert into stu_Score values('Paradox',87,80,95); insert into stu_Score values('Augenstern',93,86,90);;

3、看一下测试数据

4、实现列转行

select * from( select name,'Java' as course,Java as score from stu_Score union all select name,'C#' as course,`C#` as score from stu_Score union all select name,'Python' as course,Python as score from stu_Score)stu_Info -- name 按Dina、Paradox 、Augenstern 的顺序输出 order by (case when name = 'Dina' then 1 when name = 'Paradox' then 2 when name = 'Augenstern' then 3 end), -- course 按 Java、C#、Python 的顺序输出 (case when course = 'Java' then 1 when course = 'C#' then 2 when course = 'Python' then 3 end);

5、执行代码,可实现：

希望对你有帮助！！！ 

若想了解 MySQL 的行转列实现小示例，可点击 此处

若想了解 MySQL 的行转列 与 列转行 的应用小示例，可点击 此处