Can mysql transfer rows to columns?

Student score sheet

clipboard.png

clipboard.png

:


mysqlpivot,group_cancat

sql:


:

clipboard.png

question: is it true that mysql can"t solve the problem of row swap? Row transfer columns should be used a lot in report statistics, how to solve the problem of mysql

Mar.26,2021

there are many methods on the Internet

learn about


Don't take the sql server method, use

on mysql
Menu