node.js - Mysql export CSV then parse in nodejs with csv-parse does not find separator properly

Question

I am exporting a description field from a mysql db:

SELECT REPLACE(description, char(13), '\n') 
FROM table u  INTO OUTFILE '/var/lib/mysql-files/u.csv' 
FIELDS TERMINATED BY ',' 
ENCLOSED BY '"' 
LINES TERMINATED BY '
';

Then in nodejs I process the file using csv-parse (must use this one as it handles async):

const parse       = promisify(require('csv-parse'));
const records = await parse(fileContents, { delimiter: ',', columns: true, skip_empty_lines: true, record_delimiter: "
" });

Here is an example text:

Married, mad scientist and tennisman from Germany. I might not be able
to spell the word "ubuntu" without spellcheck software, but be sure I
know the meaning.

The parser however get it all wrong, split it in 3 fields:

'"Married, mad scientist and tennisman from Germany. I might not be
able to spell the word \"ubuntu\" without spellcheck software', 
'but be sure I know the meaning."',  
'\N'

The 3rd field comes from mysql, for some reason the file is saved with this N at the end instead of . I can remove it by sed, as well as the end of line comma, though some tips always appreciated if my query could avoid that.

However for the split of the main text in 2 fields, I am puzzled. I tried removing the delimiter parameter in parse, but same issue. I tried relax: true, same.

Any idea what am I doing wrong?

Answer 1

等待大神答复