sql.md

@@ -12,12 +12,12 @@
 ```
 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`;
 
 * 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
+对应表 ：`api_log_statistics`;
+查询条件：`time_index, user_id, api_id, data_key`;
\ No newline at end of file