我遇到的问题是我正在使用的I n to-OUTFILE语法返回了一个与“\n”相关的错误。下面是语法示例:
SELECT *
FROM tablename
WHERE work_complete = 'Yes'
INTO OUTFILE 'C:\file path for the file to be exported to\file_name.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY "''"
ESCAPED BY '\'
LINES TERMINATED BY '\n';
我花了一些时间研究这个,但没有任何运气,我甚至尝试使用
LINES TERMINATED BY '\r\n'
但错误还是一样
ERROR: Unknown command '\''.
-> LINES TERMINATED BY '\r\n';