建表语句
CREATE TABLE "test" ( "column_1" int(11) DEFAULT NULL, "column_2" varchar(10) DEFAULT NULL, "column_3" varchar(20) DEFAULT NULL) |
数据文件
43452|sisoekso|mozoa,a 59432|gg|laqpqpd 03890|lqps,rpd|gg |
加载过程
gbase> load data infile 'http://192.168.153.32/1.txt' into table test fields terminated by '|' null_value 'gg'; Query OK, 3 rows affected Task 25 finished, Loaded 3 records, Skipped 0 records |
查询入库数据
gbase> select * from test; +----------+----------+----------+ | column_1 | column_2 | column_3 | +----------+----------+----------+ | 59432 | NULL | laqpqpd | | 43452 | sisoekso | mozoa,a | | 3890 | lqps,rpd | NULL | +----------+----------+-----------+ 3 rows in set |