ツムラ_メモ

大失敗を繰り返す。

Viewを追加

 CREATE VIEW trafficphp AS SELECT fileid, line, dtime, snode, soffset, spos[0] AS sla, spos[1] AS slo, scountry, scity, sport, dnode, doffset, dpos[0] AS dla, dpos[1] AS dlo, dcountry, dcity, dport, mes FROM trafficip;
CREATE VIEW
追加予定(未チェック)
CREATE VIEW sumtrafficphp AS SELECT min(dtime), max(dtime), count(*), fileid, snode, soffset,sla, slo, scountry, scity, sport, dnode, doffset, dla, dlo, dcountry, dcity, dport, mes FROM trafficphp
GROUP BY fileid, snode, soffset, sla, slo, scountry, scity, sport, dnode, doffset, dla, dlo, dcountry, dcity, dport, mes;
CREATE VIEW sumtrafficphpnotoffset AS SELECT min(dtime), max(dtime), count(*), fileid, snode, min(soffset), max(soffset), sla, slo, scountry, scity, sport, dnode, min(doffset), max(doffset), dla, dlo, dcountry, dcity, dport, mes FROM trafficphp
GROUP BY fileid, snode, sla, slo, scountry, scity, sport, dnode, dla, dlo, dcountry, dcity, dport, mes;
CREATE VIEW sumtrafficphpnotoffset AS SELECT min(dtime), max(dtime), count(*), fileid, snode, min(soffset) AS minso, max(soffset) AS maxso, sla, slo, scountry, scity, sport, dnode, min(doffset) AS mindo, max(doffset) AS maxdo, dla, dlo, dcountry, dcity, dport, mes FROM trafficphp
GROUP BY fileid, snode, sla, slo, scountry, scity, sport, dnode, dla, dlo, dcountry, dcity, dport, mes;