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)