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);
执行结果如下:
<