mysql case when合并_MySQL如何使用Case when语句将行数据合并成列数据

MySQL如何使用Case when语句将行数据合并成列数据

如:有一个成绩表用来保存每个学生每科的成绩.

1.创建表结构

create table scores(

id integer not null

auto_increment, no int(15) not

null, type int(2), score

decimal(6,2), primary key(id)

);

2.增加测试数据.

insert into scores(no, type, score) values(10000001, 1,

80);

insert into scores(no, type, score) values(10000001, 2, 90);

insert into scores(no, type, score) values(10000001, 3, 70);

insert into scores(no, type, score) values(10000002, 1,

90);

insert into scores(no, type, score) values(10000002, 2, 85);

insert into scores(no, type, score) values(10000002, 3, 80);

insert into scores(no, type, score) values(10000003, 1,

100);

insert into scores(no, type, score) values(10000003, 2, 98);

insert into scores(no, type, score) values(10000003, 3, 99);

执行结果如下:

<