Home > Database > Mysql Tutorial > mysql数据导入到infobright中_MySQL

mysql数据导入到infobright中_MySQL

WBOY
Release: 2016-06-01 13:31:08
Original
968 people have browsed it

bitsCN.com

mysql数据导入到infobright中

 

1,在mysql中建一张表:

 

   

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

插入数据:

insert into t_mis(uid,cid,rating) values('70000','3600','5');
Copy after login

2,将数据导出csv文件:

     select * from t_mis into outfile 'F://mytable.csv' fields terminated by ',' optionally enclosed by '"' lines terminated by '/n';
Copy after login

3,在infobright中建一个表:

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

4,导入csv到表t_ib中:

     load data infile 'F://mytable.csv' into table t_ib fields terminated by ',' optionally enclosed by  '"' lines terminated by '/n';
Copy after login

5,验证:

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

 

 

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

bitsCN.com
Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template