BRIGHTHOUSE存储引擎建表时不能有AUTO_INCREMENT自增、unsigned无符号、unique唯一、主键PRIMARY KEY、索引KEY
http://blog.s135.com/infobright/
---------------------------------------
实现infobright的数据load
mysql -uroot -S /tmp/mysql-ib.sock -D web_game --skip-column-names -e "LOAD DATA INFILE '/data1/backup/web_game/analysis/myfile.csv' INTO TABLE webgame_gamelogin FIELDS TERMINATED BY ',' ENCLOSED BY '\"'"
http://blog.s135.com/infobright/
---------------------------------------
实现infobright的数据load
mysql -uroot -S /tmp/mysql-ib.sock -D web_game --skip-column-names -e "LOAD DATA INFILE '/data1/backup/web_game/analysis/myfile.csv' INTO TABLE webgame_gamelogin FIELDS TERMINATED BY ',' ENCLOSED BY '\"'"