[請益] 每天AM0:00清除 MySQL的欄位
現在我要寫一個 每日點閱數 跟 每星期點閱數 的記錄
資料格式類似以下:
ID Day Week Uptime
1 20 20 13560050
2 2 2 13560055
4 5 5 13560180
Uptime 設計成第一個點閱的寫入時間
我希望在AM0:00 過後把所有Day欄位清除成0
該怎麼做?
PS:
AM0:00 時不一定有人在線上
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 114.37.201.176
推
03/29 02:20, , 1F
03/29 02:20, 1F
→
03/29 02:36, , 2F
03/29 02:36, 2F
→
03/29 10:28, , 3F
03/29 10:28, 3F
→
03/29 18:00, , 4F
03/29 18:00, 4F
→
03/29 18:03, , 5F
03/29 18:03, 5F
→
03/29 18:04, , 6F
03/29 18:04, 6F
→
03/29 20:00, , 7F
03/29 20:00, 7F
→
03/29 20:01, , 8F
03/29 20:01, 8F
→
03/29 21:15, , 9F
03/29 21:15, 9F
推
03/30 01:01, , 10F
03/30 01:01, 10F
→
03/30 03:53, , 11F
03/30 03:53, 11F
推
03/30 19:10, , 12F
03/30 19:10, 12F
→
03/31 10:37, , 13F
03/31 10:37, 13F