... | ... | @@ -12,5 +12,5 @@ |
|
|
```
|
|
|
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 |
|
|
\ No newline at end of file |
|
|
对应表 :`api_log`
|
|
|
查询条件:`create_time,user_id,api_id,status` |
|
|
\ No newline at end of file |