mysql group测试脚本

sql数据语句：

CREATE TABLE `access` (
  `uri` varchar(100) DEFAULT NULL,
  `status` varchar(100) DEFAULT NULL,
  `worker` varchar(100) DEFAULT NULL,
  `requestCount` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

insert into access values('index','200','192.1',10);
insert into access values('index','500','192.1',10);
insert into access values('index','200','192.2',10);
insert into access values('index','500','192.2',10);

sql查询

mysql> select sum(requestCount),status,worker from access where worker='192.1'  group by uri,status,worker;
+-------------------+--------+--------+
| sum(requestCount) | status | worker |
+-------------------+--------+--------+
|                20 | 200    | 192.1  |
|                20 | 500    | 192.1  |
+-------------------+--------+--------+
2 rows in set (0.00 sec)

mysql> select sum(requestCount),status,worker from access where status='200'  group by uri,status,worker;
+-------------------+--------+--------+
| sum(requestCount) | status | worker |
+-------------------+--------+--------+
|                20 | 200    | 192.1  |
|                20 | 200    | 192.2  |
+-------------------+--------+--------+
2 rows in set (0.00 sec)