select id from tb INTO OUTFILE ?
在linux上,这条语句导出的txt文件换行符为 \n
但是部分用户电脑是windows7, 记事本没有识别 \n
为换行
所以请教下如何指定导出语句换行符为 \r\n
呢?
SELECT * FROM test_outfile
INTO OUTFILE "C:/Users/Administrator/Desktop/201909/2019-09-03.txt"
FIELDS TERMINATED BY ","
ENCLOSED BY '"';
查询结果
txt文件
你把"," 换成"\r\n
"试试