指定换行符
示例
示例中所用的表及数据:
DROP TABLE IF EXISTS gs;
CREATE TABLE gs (a int DEFAULT NULL, b varchar(20) DEFAULT
NULL);
INSERT INTO gs VALUES(3,'nihao');
INSERT INTO gs VALUES(4, 'GBase');
导出SQL 语句:
gbase> SELECT * FROM gs INTO OUTFILE '/home/gbase/temp/gs_f.txt'
LINES TERMINATED BY '@#$';
Query OK, 2 rows affected
查看导出文件:
$ cat gs_f.txt
3
nihao@#$4
GBase@#$