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 se