建表语句:
create table t(a int,b varchar(10),c varchar(10));
数据文件:
1|first
2|second
加载过程:
GBase UP 产品手册 5 数据库管理指南
文档版本04(2021-04-21) 南大通用数据技术股份有限公司 226
gbase> load data infile 'ftp://192.168.88.141/load_data/autofill.tbl' into table t
est.t fields terminated by '|' autofill;
Query OK, 2 rows affected, 3 warnings
Task 1107 finished, Loaded 2 records, Skipped 0 records
查询入库数据:
gbase> select * from t;
+------+--------+------+
| a | b | c |
+------+--------+------+
| 2 | second | NULL |
| 1 | first | NULL |
+------+--------+------+
2 rows in set