thanks velen. But I want to escape the newlines in the fields. It is annoying and new lines moves the values in separate line of excel sheet.
Thanks, Saravanan --- On Wed, 5/14/08, Velen <[EMAIL PROTECTED]> wrote: > From: Velen <[EMAIL PROTECTED]> > Subject: Re: how to escape new lines using select * into outfile > To: [EMAIL PROTECTED] > Cc: mysql@lists.mysql.com > Date: Wednesday, May 14, 2008, 1:35 AM > 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
