MySql database table row/column Conversion

MySql database table row/column Conversion
/* Create A Table grade */

Crate table grade (username varchar (45) not null, cource varchar (45) null, score int null );

/* Insert data */

Insert into grade ('username', 'cource ', 'score') values ('admin', 'English ', '80'); insert into grade ('username ', 'cource ', 'score') values ('admin', 'Math', '90'); insert into grade ('username', 'cource ', 'score ') values ('maco', 'English ', '85'); insert into grade ('username', 'cource', 'score ') values ('admin ', 'China', '85'); insert into grade ('username', 'cource ', 'score') values ('maco', 'Math', '70 '); insert into grade ('username', 'cource ', 'score') values ('maco', 'China', '68 ');

Select * from grade;/* query the row/column Conversion Result */

Select username, sum (if (cource = 'China', score, 0) as chinese, sum (if (cource = 'Math', score, 0) as math, sum (if (cource = 'English ', score, 0) as english from grade group by username;