On 04-May-01 [EMAIL PROTECTED] wrote:
> Hi Paul,
>
> I am now confronted with another problem. I need to also provide a CSV
> version.
> I need to use , seperated and " protected text. I have a copy of phpMyAdmin
> that will
> export to this format, but I need to use this at the shell.
> I h
>Hi Paul,
>Thanks for the help. I was hoping to accomplish this with MySQl, but in the
>end a script works just as good and this is just the first of several I am
>using. For what it's worth I ended up using sed. Here is is if somone else
>could use it:
>sed "s/ /|/g"
>^This is
age-
> From: Paul DuBois [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 02, 2001 9:38 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: specifying a delimiter
>
>
> At 9:11 PM -0500 5/2/01, Paul DuBois wrote:
> >At 10:01 AM -0500 5/2/01, [EMAIL PROTECTED] wrote:
At 9:11 PM -0500 5/2/01, Paul DuBois wrote:
>At 10:01 AM -0500 5/2/01, [EMAIL PROTECTED] wrote:
>>Hi,
>>Being new to MySQL, I am having a problem getting output from it to the
>>shell that is formatted the way I need. I need a table to be written to a
>>file with a delimiter.
>>something like :
>
At 10:01 AM -0500 5/2/01, [EMAIL PROTECTED] wrote:
>Hi,
>Being new to MySQL, I am having a problem getting output from it to the
>shell that is formatted the way I need. I need a table to be written to a
>file with a delimiter.
>something like :
>
>#!/bin/sh
>mysql -uroot -ptest database < sql
>