mysql 表行列转换_mysql表进行行列转换

/*create table grade(

username varchar(50) not null,

course varchar(45) null,

score int null

)

insert into grade (`username`, `course`, `score`) values ('admin', 'english', '80');

insert into grade (`username`, `course`, `score`) values ('admin', 'math', '90');

insert into grade (`username`, `course`, `score`) values ('maco', 'english', '85');

insert into grade (`username`, `course`, `score`) values ('admin', 'chinese', '85');

insert into grade (`username`, `course`, `score`) values ('maco', 'math', '70');

insert into grade (`username`, `course`, `score`) values ('maco', 'chinese', '68');

"username""course""score"

"maco""chinese""68"

"maco""math""70"

"admin""english""80"

"admin""chinese""85"

"maco""english""85"

"admin""math""90"

select * from grade;

select username,

sum(if(course='chinese',score,0)) as chinese,

sum(if(course='math',score,0)) as math,

sum(if(course='english',score,0)) as english

from grade group by username

"username""chinese""math""english"

"admin""85""90""80"

"maco""68""70""85"

*/