MySQL table transverse transpose SQL statement

ID, student, course, mark
1, Zhang San, Chinese, 90
2, John Doe, Chinese, 80
3, Zhang San, mathematics, 70
4, John Doe, mathematics, 80

Now you want to use the Transpose table method to go to the two-dimensional table output, the required format is:

Student, Chinese, maths
Zhang San, 90, 70
John Doe, 80, 80

select student,      sum(if(course=‘语文‘,mark,0)) as 语文,      sum(if(course=‘数学‘,mark,0)) as 数学 from table1  group by student

1 A 2 b 1 c 2 D Merge to 1 a,c 2 B,d   select group_concat(column_b,separator ‘,‘) from table_name group by column_a;