gbase8a 使用NULL_VALUES指定空值字符加载数据文件

建表语句

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