OpenSim/DB/0.9.0/totalsales
をテンプレートにして作成
[
トップ
] [
タイトル一覧
|
ページ一覧
|
新規
|
検索
|
最終更新
|
ヘルプ
|
ログイン
]
開始行:
*** Columns [#wf28b968]
mysql> show columns from totalsales;
+-------------+--------------+------+-----+---------+---...
| Field | Type | Null | Key | Default | Ex...
+-------------+--------------+------+-----+---------+---...
| 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 [#ja0fcc59]
- transactions テーブルから生成
SELECT receiver,objectUUID,type,COUNT(*),SUM(amount) FRO...
GROUP BY receiver,objectUUID,type;
終了行:
*** Columns [#wf28b968]
mysql> show columns from totalsales;
+-------------+--------------+------+-----+---------+---...
| Field | Type | Null | Key | Default | Ex...
+-------------+--------------+------+-----+---------+---...
| 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 [#ja0fcc59]
- transactions テーブルから生成
SELECT receiver,objectUUID,type,COUNT(*),SUM(amount) FRO...
GROUP BY receiver,objectUUID,type;
ページ名:
![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
