行转列
SELECT name,
SUM(CASE `subject` WHEN '语文' THEN score ELSE 0 END) as '语文',
SUM(CASE `subject` WHEN '数学' THEN score ELSE 0 END) as '数学'
FROM tj_testscore
GROUP BY name
转化后
拼接每个转化后的表
SELECT
A.CID,
A.jk_height,
A.jk_weight,
A.site,
A.shop,
A.team,
B.yw,
B.sx
FROM
tj_in AS A
INNER JOIN tj_scorez AS B ON A.Name = B.Name
方案一
定时行转列,同步到新表,执行拼接语句,对应到一个大对象中。
方案二
定时行转列,放到临师表,再拼接。
方案一,简化了sql语句。