56,685
社区成员
发帖
与我相关
我的任务
分享
mysql> select * from t_dawenwen1128;
+-------+--------+---------+
| c_id | c_name | c_namef |
+-------+--------+---------+
| 10001 | 沙 | 10.12 |
| 10001 | 石 | 10.12 |
| 10001 | 煤 | 10.12 |
| 10002 | 沙 | 10.12 |
| 10002 | 水 | 10.12 |
| 10002 | 盐 | 10.12 |
+-------+--------+---------+
6 rows in set (0.06 sec)
mysql> select c_id,
-> SUBSTRING_INDEX(k,',',1) as name1,
-> SUBSTRING_INDEX(SUBSTRING_INDEX(k,',',2),',',-1) as name2,
-> SUBSTRING_INDEX(SUBSTRING_INDEX(k,',',3),',',-1) as name3
-> from (
-> select c_id,group_concat(c_namef) as k
-> from t_dawenwen1128
-> group by c_id
-> ) t ;
+-------+-------+-------+-------+
| c_id | name1 | name2 | name3 |
+-------+-------+-------+-------+
| 10001 | 10.12 | 10.12 | 10.12 |
| 10002 | 10.12 | 10.12 | 10.12 |
+-------+-------+-------+-------+
2 rows in set (0.00 sec)
mysql>