sql.md

@@ -13,6 +13,25 @@ select remain_times,used_times from `user_account` where `user_id` = 1 order by
 SELECT time_index,data_value FROM user_account_log_statistics WHERE user_id = 1 AND data_key = 'consumption' AND time_index > 20160808 AND  time_index < 20160816;
 ```
 
+* Bin_Credit_AccountLogStatistics 脚本
+```
+SELECT user_id,type,COUNT(0) AS data_value FROM user_account_log WHERE times =20160816 GROUP BY user_id,type
+```
+对应表 ：`user_account_log`;
+查询条件：`times, user_id, type`;
+
+* Bin_Credit_AccountLogStatistics 脚本
+```
+INSERT INTO personal_credit.user_account_log_statistics (user_id, time_index, data_key , data_value, create_time) VALUES
+  ('1','20160816','consumption','88',UNIX_TIMESTAMP(NOW())),
+  ('1','20160816','csdkfksfs','88',UNIX_TIMESTAMP(NOW())),
+  ('2','20160816','consumption','88',UNIX_TIMESTAMP(NOW())),
+  ('2','20160816','csdkfksfs','88',UNIX_TIMESTAMP(NOW())),
+  ('3','20160816','consumption','88',UNIX_TIMESTAMP(NOW()))ON DUPLICATE KEY UPDATE data_value = VALUES(data_value)
+```
+对应表 ：`user_account_log_statistics`;
+查询条件：`time_index,user_id,data_key,data_value`;
+
 * Bin_Credit_ApiLogStatistics 脚本
 ```
 SELECT user_id, api_id, status, count(0) FROM personal_credit.api_log WHERE create_time >= 1471190400 AND create_time < 1471276800 GROUP BY user_id, api_id, status WITH ROLLUP HAVING user_id IS NOT NULL AND api_id IS NOT NULL