示例中用到的表及数据:
DROP TABLE IF EXISTS gs;
CREATE TABLE gs (a int DEFAULT NULL, b varchar(20) DEFAULT NULL);
INSERT INTO gs values(1,'qwer'),(2,'asdf');
示例1:指定单个字段包围符为“@”。
GBase UP 产品手册 5 数据库管理指南
文档版本04(2021-04-21) 南大通用数据技术股份有限公司 239
gbase>
SELECT
*
FROM
gs
INTO
OUTFILE
'/home/gbase/temp/gs_b.txt'
FIELDS
ENCLOSED
BY
'@';
Query OK, 2 rows affected
查看导出文件:
$ cat gs_b.txt
@1@ @qwer@
@2@ @asdf@
示例2:无OPTIONALLY 选项时对所有字段都起作用。
gbase> SELECT * FROM gs INTO OUTFILE '/home/gbase/temp/gs_c.txt' FIELDS ENCLOSED BY
'"';
Query OK, 2 rows affected
查看导出文件:
$ cat gs_c.txt
"1" "qwer"
"2" "asdf"
示例3:指定OPTIONALLY 选项时仅对字符串类型起作用。
gbase> SELECT * FROM gs INTO OUTFILE '/home/gbase/temp/gs_d.txt' FIELDS OPTIONALLY
ENCLOSED BY '"';
Query OK, 2 rows affected
查看导出文件:
$ cat gs_d.txt
1 "qwer"
2 "asdf"