说明:
ENCLOSED BY:用于指定字段包围符,支持任意单字符,参数值以单引号包围,仅当使用文本方式加载时有效。可使用字符本身(仅限可见字符,如:"|")、 C 风格转义字符(如: “\a”)、 \xhh 十六进制(如: “\xFF”)或 x’‘十六进制(如:"x’09’")四种方式指定。
加载示例:
部分数据文件:
1|1551894|76910|1|17|33078.94|0.04|0.02|N|O|1996-03-13|1996-02-12|1996-03-22|"WHO ARE YOU"|TRUCK|egular courts above the|
1|673091|73092|2|36|38306.16|0.09|0.06|N|O|1996-04-12|1996-02-28|1996-04-20|"Take BACK"|MAIL|ly final dependencies: slyly bold |
加载过程:
gbase> LOAD DATA INFILE 'ftp://192.168.0.1/pub/lineitem.tbl' INTO TABLE test.lineitem
FIELDS TERMINATED BY '|' ENCLOSED BY '"';
Query OK, 12000000 rows affected
Task 1 finished, Loaded 12000000 records, Skipped 0 records