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 esca
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"
Sent: Tuesday, May 13, 2008 9:26 PM
Subject: how to escape new lines using
So far as I've been able to figure out, there's no form of escaping that
will convince Excel to do what you want.
The only thing I can think of is to replace * with a list of fields, and use
MySQL functions to replace the \n with something else.
Regards,
Jerry Schwartz
The Infoshop by Global Inf
