假设 我有一张表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
....一条语句
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
....一条语句
select a,b,group_concat(c SEPARATOR ' , ') from tt group by a,b
| 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; 按楼上几位兄弟写的,能查询出来,但是插入怎么写?
(select a,b,group_concat(c,SEPARATOR ' , ') from table1 group by a,b)
这样就可以了。mysql文档中有这样的用法