how to escape new lines using select * into outfile

[Saravanan <suzuki_babu@xxxxxxxxx>]

Hi all,

I want to export the values based on the condition. I export them as csv. 

select * into outfile 'filename.csv' from table;

the problem is one field in table has many lines, means with \n. I couldn't import the values into the xls sheet.

any ideas how to escape the new line characters?

Thanks,
Saravanan


      

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx