GBase 8a导出和加载时,可以指定字符串的包围符,但只支持最多1个字符,如果指定了多个,则会报 ERROR 1755 (HY000): (GBA-02SC-1001) FIELDS ESCAPED STRING must be only one byte
目录导航
报错样例
gbase> select id,value from t1 into outfile '/home/gbase/t1.txt' fields terminated by x'fffefd' escaped by '\xee\xdd' writemode by overwrites;
ERROR 1755 (HY000): (GBA-02SC-1001) FIELDS ESCAPED STRING must be only one byte
gbase>
解决方案
改成只有1个包围符
gbase> select id,value from t1 into outfile '/home/gbase/t1.txt' fields terminated by x'fffefd' escaped by '\xee' writemode by overwrites;
Query OK, 5 rows affected, 1 warning (Elapsed: 00:00:00.02)