最大列数固定的话可以,试一下
select A,
substr(B,instr(b,',')-1) as b1,
substr(B,instr(b,',')+1,instr(b,',',2)-substr(B,instr(b,',',1)-1)) as b2,
substr(B,instr(b,',',2)+1,instr(b,',',3)-substr(B,instr(b,',',2)-1)) as b3,
substr(B,instr(b,',',3)+1,instr(b,',',4)-substr(B,instr(b,',',3)-1)) as b4,
c from table