MySQL Infobright-数据仓库笔记[转]

BRIGHTHOUSE存储引擎建表时不能有AUTO_INCREMENT自增、unsigned无符号、unique唯一、主键PRIMARYKEY、索引KEY

http://blog.s135.com/infobright/

---------------------------------------

实现infobright的数据load

mysql-uroot-S/tmp/mysql-ib.sock-Dweb_game--skip-column-names-e"LOADDATAINFILE'/data1/backup/web_game/analysis/myfile.csv'INTOTABLEwebgame_gameloginFIELDSTERMINATEDBY','ENCLOSEDBY'\"'"