Mysql 查询文件中的定界符

Question

在下面的查询中，如果 desc 中包含“\”，并且当 openoffice 打开该文件时，\会出现在不同的位置中。城市列也会发生这种情况，如何重述这一点..

select first_name, last_name, emp_id,desc,city from emp_table where event_id = 4 order by city asc   into OUTFILE "/tmp/Sep10-1.csv"   FIELDS TERMINATED BY ",";

Answer 1

添加 ESCAPED BY 子句以转义转储中的特殊字符。

select 
  first_name, last_name, emp_id,desc,city 
from 
  emp_table 
where 
  event_id = 4 
order by 
  city asc   
into OUTFILE 
  "/tmp/Sep10-1.csv"   
FIELDS 
  TERMINATED BY "," 
  ESCAPED BY "\";