mysql 导出txt文本 INTO OUTFILE 语句如何指定换行符\r\n?

Question

select id from tb INTO OUTFILE ?

在linux上，这条语句导出的txt文件换行符为 \n

但是部分用户电脑是windows7, 记事本没有识别 \n 为换行

所以请教下如何指定导出语句换行符为 \r\n 呢？

Answer 1

SELECT * FROM test_outfile
INTO OUTFILE "C:/Users/Administrator/Desktop/201909/2019-09-03.txt"
FIELDS TERMINATED BY ","
ENCLOSED BY '"';
查询结果

txt文件

你把"," 换成"\r\n"试试