-
mysql数据导入到infobright中1,在mysql中建一张表:1234
create
table
t_mis(
uid mediumint
not
null
,
cid
smallint
not
null
,
rating tinyint
not
null
)engine=MyISAM;
插入数据:1insert
into
t_mis(uid,cid,rating)
values
(
'70000'
,
'3600'
,
'5'
);
2,将数据导出csv文件:1select
*
from
t_mis
into
outfile
'F:\\mytable.csv'
fields terminated
by
','
optionally enclosed
by
'"'
lines terminated
by
'\n'
;
3,在infobright中建一个表:1234create
table
t_ib(
uid mediumint
not
null
,
cis
smallint
not
null
,
rating tinyint
not
null
)engine=brighthouse;
4,导入csv到表t_ib中:1load
data infile
'F:\\mytable.csv'
into
table
t_ib fields terminated
by
','
optionally enclosed
by
'"'
lines terminated
by
'\n'
;
5,验证:12345678mysql>
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
mysql数据导入到infobright中
最新推荐文章于 2024-08-08 18:50:15 发布