一行"aaa,bbb,ccc"怎么转换成多列
"aaa"
"bbb"
"ccc"
This topic created in 3168 days ago, the information mentioned may be changed or developed.
 |
linyinmaMar 9, 2018
1
REPLACE(table.column , ',', char(10));
将','替换成‘\n ’ |
 |
gbinMar 9, 2018
2
substring_index(`table.column`,',',1) as c1, substring_index(substring_index(`table.column`,',',-2),',',1) as c2, substring_index(substring_index(`table.column`,',',-1),',',1) as c3;
参考： https://stackoverflow.com/questions/1096679/can-mysql-split-a-column |
 |
rieuseMar 9, 2018 via Android
4
split_part 你看看
|
 |
3a3Mp112Mar 9, 2018
5
java 读出来拆分重新写进去方便。
|
 |
7
|
1
Select Language