Mysql对行求和_mysql 行转列，对列的分组求和，对行求和

CREATE TABLE students(

id INT PRIMARY KEY,

NAME VARCHAR(11)

);

CREATE TABLE courses(

id INT PRIMARY KEY,

NAME VARCHAR(11)

);

CREATE TABLE scores(

sid INT,

cid INT,

score INT,

RIMARY KEY (sid,cid)

);

3表关联查询：

SELECT st.id,st.name,c.NAME course,sc.score FROM students st

LEFT JOIN scores sc ON st.id=sc.sid

LEFT JOIN courses c ON sc.cid=c.id