seakingx
金牌会员
 
UID 75142
精华
0
积分 1264
帖子 801
金钱 663 喜悦币
威望 0
人脉 601
阅读权限 70
注册 2006-6-18
来自 海口
状态 离线
|
[推荐阅读] 找工作啦，我在深圳，各位兄弟帮忙啦。。
mysql> create table f2(
-> pic_id int,
-> cur_day char(20) default '',
-> day_view int default 0,
-> cur_month char(20) default '' ,
-> month_view int default 0 );
Query OK, 0 rows affected (0.10 sec)
mysql>
mysql> insert into f2(pic_id) values(1);
Query OK, 1 row affected (0.02 sec)
mysql>
mysql> update f2 set day_view = day_view+1 where cur_day=DATE_FORMAT(Now(),'%Y-%
m-%d');
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0
mysql> update f2 set day_view = 1 , cur_day = DATE_FORMAT(Now(),'%Y-%m-%d') whe
re cur_day!=DATE_FORMAT(Now(),'%Y-%m-%d');
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql>
mysql> update f2 set month_view = month_view+1 where cur_month=DATE_FORMAT(Now()
,'%Y-%m');
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0
mysql> update f2 set month_view = 1 , cur_month = DATE_FORMAT(Now(),'%Y-%m') wh
ere cur_month!=DATE_FORMAT(Now(),'%Y-%m');
Query OK, 1 row affected (0.02 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> select * from f2;
+--------+------------+----------+-----------+------------+
| pic_id | cur_day | day_view | cur_month | month_view |
+--------+------------+----------+-----------+------------+
| 1 | 2007-03-10 | 1 | 2007-03 | 1 |
+--------+------------+----------+-----------+------------+
1 row in set (0.00 sec)
mysql> update f2 set day_view = day_view+1 where cur_day=DATE_FORMAT(Now(),'%Y-%
m-%d');
Query OK, 1 row affected (0.02 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> update f2 set day_view = 1 , cur_day = DATE_FORMAT(Now(),'%Y-%m-%d') whe
re cur_day!=DATE_FORMAT(Now(),'%Y-%m-%d');
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0
mysql>
mysql> update f2 set month_view = month_view+1 where cur_month=DATE_FORMAT(Now()
,'%Y-%m');
Query OK, 1 row affected (0.02 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> update f2 set month_view = 1 , cur_month = DATE_FORMAT(Now(),'%Y-%m') wh
ere cur_month!=DATE_FORMAT(Now(),'%Y-%m');
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0
mysql> select * from f2;
+--------+------------+----------+-----------+------------+
| pic_id | cur_day | day_view | cur_month | month_view |
+--------+------------+----------+-----------+------------+
| 1 | 2007-03-10 | 2 | 2007-03 | 2 |
+--------+------------+----------+-----------+------------+
1 row in set (0.00 sec)
mysql> update f2 set day_view = day_view+1 where cur_day=DATE_FORMAT(Now(),'%Y-%
m-%d');
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> update f2 set day_view = 1 , cur_day = DATE_FORMAT(Now(),'%Y-%m-%d') whe
re cur_day!=DATE_FORMAT(Now(),'%Y-%m-%d');
Query OK, 0 rows affected (0.01 sec)
Rows matched: 0 Changed: 0 Warnings: 0
mysql>
mysql> update f2 set month_view = month_view+1 where cur_month=DATE_FORMAT(Now()
,'%Y-%m');
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> update f2 set month_view = 1 , cur_month = DATE_FORMAT(Now(),'%Y-%m') wh
ere cur_month!=DATE_FORMAT(Now(),'%Y-%m');
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0
mysql> select * from f2;
+--------+------------+----------+-----------+------------+
| pic_id | cur_day | day_view | cur_month | month_view |
+--------+------------+----------+-----------+------------+
| 1 | 2007-03-10 | 3 | 2007-03 | 3 |
+--------+------------+----------+-----------+------------+
1 row in set (0.00 sec)
| 
锐升科技 |
|
