mysql - 在mysql中使用 "load data into outfile"时如何转义(\t\n\r)？

Question

mysql中使用“load data into outfile”时如何转义(\t\n\r)？

我尝试过这样做:

select * from user INTO OUTFILE FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' 

但是好像不行

我需要一个例子。

谢谢

如果我将一个值插入到字段 var 中，内容为“\r\n”:

+----+------+------+
| id | var  | var2 |
+----+------+------+
|  1 | 
   | test |
+----+------+------+

然后，运行

SELECT * FROM `test` into OUTFILE '/tmp/out.log' FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\r\n';

“out.log”:

1       \
        test

ASCII:31 09 5c 0d 0a 09 74 65 73 74 0d 0a

但我想逃避0d 0a

Answer 1

select * from user INTO OUTFILE 'path' FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\r\n';