将下标显示成右边的形式,列转行的使用。
SELECT
name,
MAX(
CASE
WHEN week='1' THEN
course
END
)as '星期一',
MAX(
CASE
WHEN week='2' THEN
course
END
)as '星期二',
MAX(
CASE
WHEN week='3' THEN
course
END
)as '星期三',
MAX(
CASE
WHEN week='4' THEN
course
END
)as '星期四',
MAX(
CASE
WHEN week='5' THEN
course
END
)as '星期五'
FROMteacher
GROUP BY name