mysql数据导入到infobright中

mysql数据导入到infobright中

 

1，在mysql中建一张表：

 

   

?

1 2 3 4

create table t_mis(     uid mediumint not null ,     cid smallint not null ,     rating tinyint not null )engine=MyISAM;

 

 

插入数据：

?

1	insert into t_mis(uid,cid,rating) values ( '70000' , '3600' , '5' );

 

 

2，将数据导出csv文件：

 

?

1	select * from t_mis into outfile 'F:\\mytable.csv' fields terminated by ',' optionally enclosed by '"' lines terminated by '\n' ;

 

 

3，在infobright中建一个表：

 

?

1 2 3 4

create table t_ib( uid mediumint not null , cis smallint not null , rating tinyint not null )engine=brighthouse;

 

 

4，导入csv到表t_ib中：

 

?

1	load data infile 'F:\\mytable.csv' into table t_ib fields terminated by ',' optionally enclosed by  '"' lines terminated by '\n' ;

 

 

5，验证：

 

?

1 2 3 4 5 6 7 8

mysql> select * from t_ib;   + -------+------+--------+ | uid   | cis  | rating | + -------+------+--------+ | 70000 | 3600 |      5 | + -------+------+--------+ 2 rows in set (0.05 sec)

 

 

ok了，这样mysql中的数据就能导入到infobright中了
。

http://www.2cto.com/database/201308/234124.html