指定字段分隔符
示例
示例中所用的表及数据：
DROP TABLE IF EXISTS cust;
CREATE
TABLE
cust(c_id
INT,
c_name
VARCHAR(20),
c_addr
VARCHAR(100));
INSERT INTO cust VALUES (1, 'xiaoming', 'Tianjin');
INSERT INTO cust VALUES (3, 'qiaorui', 'Hebei');
INSERT INTO cust VALUES (4, 'tianfei', 'Anhui');
INSERT INTO cust VALUES (2, 'zhangling', 'Hunan');
导出SQL 语句，指定字段分隔符为“,”：
gbase>
rmt:SELECT
*
FROM
cust
INTO
OUTFILE
'/home/gbase/temp/cust.txt' FIELDS TERMINATED BY ',';
Query OK, 4 rows affected
查看导出文件：
查看导出文件：
$ cat cust.txt
1,xiaoming,Tianjin
3,qiaorui,Hebei
4,tianfei,Anhui
2,zhangling,Hunan
导出SQL 语句，指定字段分隔符为“;”：
gbase>
rmt:SELECT
*
FROM
cust
INTO
OUTFILE
'/home/gbase/temp/cust.txt' FIELDS TERMINATED BY ';';
Query OK, 4 rows affected
查看导出文件：
$ cat cust.txt
1;xiaoming;Tianjin
3;qiaorui;Hebei
4;tianfei;Anhui
2;zhangling;Hunan