mysql问题:将行存储转成列存储
e.g. 比如一行数据既有语文成绩,也有数学成绩,如何转换一行数据只有语文或只有数据
1、按照长度划分👇:
select
substring(stu_id,1,3) id1,
substring(stu_id,4) id2
from student;
2、还有一种用特定分隔符分割的方法👇:
以下是分割方法:
select
cast(substring_index(score,',',1) as unsigned) as s1,
cast(substring_index(score,',',-1) as unsigned )as s2
from score;
分割效果: