sql

This is an old version of this page. You can view the most recent version or browse the history.

＃＃＃查询消费记录

对应表：user_account 查询条件：user_id

对应表：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