Columns 
mysql> show columns from totalsales; +-------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+---------+-------+ | UUID | varchar(36) | NO | PRI | NULL | | | user | varchar(128) | NO | | NULL | | | objectUUID | varchar(36) | YES | | NULL | | | type | int(10) | NO | | NULL | | | TotalCount | int(10) | NO | | 0 | | | TotalAmount | int(10) | NO | | 0 | | +-------------+--------------+------+-----+---------+-------+ 7 rows in set (0.00 sec)
Command
- transactions テーブルから生成
SELECT receiver,objectUUID,type,COUNT(*),SUM(amount) FROM transactions WHERE sender<>receiver AND status=0 GROUP BY receiver,objectUUID,type;
Counter: 756,
today: 2,
yesterday: 1
最終更新: 2016-05-21 (土) 18:52:08 (JST) (2890d) by iseki
