sql.md

 ＃＃＃查询消费记录
 
-* Credit_User_ConsumeHistoryController 控制器  get_account方法
-
+1.
 对应表 ：user_account
 查询条件：user_id 
 
-* Credit_User_ConsumeHistoryController 控制器  get_date_account方法
-
-SELECT time_index,data_value FROM user_account_log_statistics WHERE user_id = 1 AND time_index >=20160801 AND  time_index < 20160813 AND data_key = 'consumption'
-
+2.
 对应表 ：user_account_log_statistics 
 查询条件：user_id ，time_index，data_key(这个字段暂时只有两种不同的值)
 
-
 * 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
 ```
-对应表 ：api_log 
-查询条件：create_time,user_id,api_id,status
+对应表 ：`api_log`
+查询条件：`create_time,user_id,api_id,status`
\ No newline at end of file
+
+* Bin_Credit_ApiLogStatistics 脚本
+```
+INSERT INTO personal_credit.api_log_statistics (time_index, user_id, api_id, data_key, data_value, create_time) VALUES (20160815, 1, 1,  'call_error', 2, UNIX_TIMESTAMP(NOW())),(20160815, 1, 1,  'call_success', 2, UNIX_TIMESTAMP(NOW())),(20160815, 1, 1,  'call_total', 4, UNIX_TIMESTAMP(NOW())),(20160815, 1, 3,  'call_success', 1, UNIX_TIMESTAMP(NOW())),(20160815, 1, 3,  'call_total', 1, UNIX_TIMESTAMP(NOW())),(20160815, 2, 1,  'call_success', 1, UNIX_TIMESTAMP(NOW())),(20160815, 2, 1,  'call_total', 1, UNIX_TIMESTAMP(NOW()))ON DUPLICATE KEY UPDATE data_value = VALUES(data_value)
+```
+对应表 ：`api_log_statistics`
+查询条件：`time_index, user_id, api_id, data_key`
\ No newline at end of file