一行"aaa,bbb,ccc"怎么转换成多列
"aaa"
"bbb"
"ccc"
This topic created in 3047 days ago, the information mentioned may be changed or developed.
 |
1
linyinma Mar 9, 2018
REPLACE(table.column , ',', char(10));
将','替换成‘\n ’ |
 |
2
gbin Mar 9, 2018
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 |
 |
4
rieuse Mar 9, 2018 via Android
split_part 你看看
|
 |
5
3a3Mp112 Mar 9, 2018
java 读出来拆分重新写进去方便。
|
 |
7
mario85 Mar 9, 2018  1
|
Select Language