sql统计每天PV总量

来源：互联网发布：淘宝上如何找真弩编辑：程序博客网时间：2024/05/17 04:17

1、建表：

mysql> create table cal_pv (id int auto_increment primary key, pv int, date varchar(255));

2、插入测试数据

mysql> insert into cal_pv values(0, 115, '2015-8-27');
Query OK, 1 row affected (0.00 sec)

mysql> insert into cal_pv values(0, 118, '2015-8-27');
Query OK, 1 row affected (0.02 sec)

mysql> insert into cal_pv values(0, 110, '2015-8-27');
Query OK, 1 row affected (0.03 sec)

mysql> insert into cal_pv values(4, 111, '2015-8-27');
Query OK, 1 row affected (0.01 sec)

3、查看表

mysql> select * from cal_pv;
+----+------+-----------+
| id | pv | date |
+----+------+-----------+
| 1 | 115 | 2015-8-27 |
| 2 | 118 | 2015-8-27 |
| 3 | 110 | 2015-8-27 |
| 4 | 111 | 2015-8-27 |
+----+------+-----------+
4 rows in set (0.00 sec)

5、统计

mysql> select date, sum(pv) from cal_pv where date='2015-8-27';
+-----------+---------+
| date | sum(pv) |
+-----------+---------+
| 2015-8-27 | 454 |
+-----------+---------+
1 row in set (0.00 sec)

0 0