请教SQL 语句 （多行字段 变成一行显示结果）

Question

假设 我有一张表table1，内容如下：a          b             c
11         888          K001
11         888          K002
11         888          K003
22         888          K011
22         888          K012
22         888          K013
33         888          KKK1
33         888          KKK2
66         888          22XX
66         888          23X2
.....我怎么写语句，插入到table2得到如下的结果？
a     b        c11    888   K001, K002 , K003
22    888   K011 , K012 , K013
33    888   KKK1 , KKK2
66    888   22XX , 23X2
....一条语句

Answer 1

select a,b,group_concat(c) from tt group by a,b

Answer 2

select a,b,group_concat(c,SEPARATOR ' , ') from tt group by a,b

Answer 3

select a,b,group_concat(c SEPARATOR ' , ') from tt group by a,b

Answer 4

table1+------+-------+--------+-------------+-----------+
| id   | code  | name   | checkInDate | checkTime |
+------+-------+--------+-------------+-----------+
| 1011 | 00111 | 蔡鹏   | 2012-03-06  | 08:22:00  |
| 1012 | 00111 | 蔡鹏   | 2012-03-06  | 08:28:00  |
| 1013 | 00111 | 蔡鹏   | 2012-03-06  | 18:18:00  |
| 1014 | 00111 | 蔡鹏   | 2012-03-07  | 08:22:00  |
| 1015 | 00111 | 蔡鹏   | 2012-03-07  | 18:26:00  |
| 1016 | 00111 | 蔡鹏   | 2012-03-08  | 08:26:00  |
| 1017 | 00111 | 蔡鹏   | 2012-03-08  | 17:47:00  |
| 1018 | 00111 | 蔡鹏   | 2012-03-09  | 08:26:00  |
| 1019 | 00111 | 蔡鹏   | 2012-03-09  | 18:19:00  |
| 1020 | 00112 | 李志桥 | 2012-02-29  | 08:23:00  |
| 1021 | 00112 | 李志桥 | 2012-02-29  | 21:36:00  |
| 1022 | 00112 | 李志桥 | 2012-03-01  | 08:25:00  |
| 1023 | 00112 | 李志桥 | 2012-03-01  | 22:00:00  |table2+----+-------+------+-------------+-------------+--------------+----------+----------+
| id | code  | name | checkInDate | checkInTime | checkOutTime | lateTime | overTime |
+----+-------+------+-------------+-------------+--------------+----------+----------+
|  1 | 00111 | 蔡鹏 | 2012-03-06  | 08:22:00    | 18:18:00     | NULL     | 00:48:00 |
+----+-------+------+-------------+-------------+--------------+----------+----------+select code,name,checkInDate,group_concat(checkTime),max(checkTime),min(checkTime) from hk_attence group by code,name,checkInDate;  按楼上几位兄弟写的，能查询出来，但是插入怎么写？

Answer 5

insert into tables(a,b,c)
(select a,b,group_concat(c,SEPARATOR ' , ') from table1 group by a,b)
这样就可以了。mysql文档中有这样的用法