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;