Try using: select * into outfile 'filename.csv' fields enclosed by '"' terminated by ',' lines terminated by '\n' from table
Regards, Velen ----- Original Message ----- From: "Saravanan" <[EMAIL PROTECTED]> To: "mysql" <mysql@lists.mysql.com> Sent: Tuesday, May 13, 2008 9:26 PM Subject: how to escape new lines using select * into outfile > 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/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
