MySQL Forums
Forum List  »  CSV Storage Engine

Issue when export a table to CSV file
Posted by: Jingyu Qi
Date: January 21, 2009 09:59PM

Hi all,

I have a table, in which a particular field may have a string with "\n" char. So when I try to export this table to csv file, the record with this field will be seperated to two lines, not like other records. I am using "\n" as LINES TERMINATED BY. I was trying to use "FIELDS ESCAPED BY '\'", but got errors.

I need find a way to replace the "\n" in the filed to white space.

Thanks,
Jingyu.

Options: ReplyQuote


Subject
Views
Written By
Posted
Issue when export a table to CSV file
11554
January 21, 2009 09:59PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.