示例中用到的表及数据:
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');
示例1:不指定字段分隔符,即使用默认字段分隔符“\t”。
gbase> rmt:SELECT * FROM cust INTO OUTFILE '/home/gbase/temp/cust.txt';
查看导出文件:
$ cat cust.txt
1 xiaoming Tianjin
3 qiaorui Hebei
4 tianfei Anhui
2 zhangling Hunan