|
+------+------+------+--------+-------------------------------------
800000 rows in set
导出SQL 语句:
gbase> SELECT * FROM test INTO OUTFILE '/home/gbase/temp/test.tbl'
fields terminated by ‘|’ with head;
Query OK, 800000 rows affected
查看导出文件:
$ cat test.tbl
ps_partkey| ps_suppkey| ps_availqty| ps_supplycost| ps_comment
1|2|3325|771.64|, even theodolites. Regular
GBase 8a MPP Cluster 产品手册
5 数据库管理指南
文档版本953(2022-04-10)
南大通用数据技术股份有限公司
1249
1|2502|8076|993.49|ven ideas. quickly
1|5002|3956|337.09|after the fluffily ironic
......
......