windows下玩infobright记录点滴

悠奕6782

　　http://www.infobright.org/Download/ICE
　　下载 windows版安装
　　
　　创建表：
　　CREATE TABLE `game_test` (
  `agent_name` VARCHAR(20) NOT NULL,
  `server_name` VARCHAR(20) NOT NULL,
  `player_id` VARCHAR(50) NOT NULL,
  `role_name` VARCHAR(30) NOT NULL,
  `order_number` VARCHAR(40) NOT NULL,
  `money` VARCHAR(10) NOT NULL,
  `mo_type` VARCHAR(4) NOT NULL,
  `rmb` VARCHAR(10) NOT NULL,
  `coin` INT(20) NOT NULL,
  `dt` INT(11) NOT NULL
) ENGINE=BRIGHTHOUSE DEFAULT CHARSET=utf8
　　
　　
　　加载TXT
　　LOAD DATA INFILE 'E:\frxz2_2010-01-01_2012-05-26___orders___user-defined.txt' INTO TABLE game_test  FIELDS TERMINATED BY '\t'
　　
　　生成数据：
　　SELECT agent_name,COUNT(DISTINCT(player_id)),COUNT(*),SUM(coin) INTO OUTFILE 'D:\1.csv'  FROM game_test GROUP BY agent_name;