gbase> select * from t100w into outfile 'sftp://u1:123456@10.0.0.50/home/u1/t100w.data' fields terminated by '@|@' enclosed by '\'' lines terminated by '&^&' null_value 'NULL' escape by '';
sql导入用法
load data infile 'sftp://u1:123456@10.0.0.50/home/u1/t100w.data/t100w.data' into table t1 data_format 3 having lines separator fields terminated by '@|@' enclosed by '\'' lines terminated by '&^&' null_value 'NULL' max_bad_records 0;