On 3/14/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
>
> "Jake Peavy" <[EMAIL PROTECTED]> wrote on 03/14/2006 01:52:28 PM:
>
>
> > On 3/10/06, Jake Peavy <[EMAIL PROTECTED]> wrote:
> > >
> > > On 3/7/06, C.R.Vegelin <[EMAIL PROTECTED]> wrote:
> > >
> > > > Hi Ariel,
> > > >
> > > > Maybe th
"Jake Peavy" <[EMAIL PROTECTED]> wrote on 03/14/2006 01:52:28 PM:
> On 3/10/06, Jake Peavy <[EMAIL PROTECTED]> wrote:
> >
> > On 3/7/06, C.R.Vegelin <[EMAIL PROTECTED]> wrote:
> >
> > > Hi Ariel,
> > >
> > > Maybe this example helps you to create CSV output from MySQL.
> > > The first SELECT gene
On 3/10/06, Jake Peavy <[EMAIL PROTECTED]> wrote:
>
> On 3/7/06, C.R.Vegelin <[EMAIL PROTECTED]> wrote:
>
> > Hi Ariel,
> >
> > Maybe this example helps you to create CSV output from MySQL.
> > The first SELECT generates the headerline; the second the data.
> > ( SELECT 'FieldA','FieldB','FieldC',
On 3/7/06, C.R.Vegelin <[EMAIL PROTECTED]> wrote:
> Hi Ariel,
>
> Maybe this example helps you to create CSV output from MySQL.
> The first SELECT generates the headerline; the second the data.
> ( SELECT 'FieldA','FieldB','FieldC', ... )
> UNION
> ( SELECT `FieldA`, `FieldB`, `FieldC`, ...
> INTO
Hi Ariel,
Maybe this example helps you to create CSV output from MySQL.
The first SELECT generates the headerline; the second the data.
( SELECT 'FieldA','FieldB','FieldC', ... )
UNION
( SELECT `FieldA`, `FieldB`, `FieldC`, ...
INTO OUTFILE 'D:/MySQL Datafiles/myFile.csv'
FIELDS TERMINATED BY '
Maybe, if you make a file with the SELECT content and call them
from the OS shell, like this:
SELECT table1.a, tabela1.b, table1.c FROM mydatabase.table;
After, call this file from the OS shell:
shell>mysql -A mydatabase < my_file
This will result on the screen. You can direct the result to a
At 14:12 -0600 3/6/06, Ariel Sánchez Mora wrote:
When using select into outfile, I can only get
the table data, but I can't find how to include
the column names. I haven't been able to include
the column names into the actual return of the
query, and they don't get stored in the .csv
Anyone
Ariel Sánchez Mora <[EMAIL PROTECTED]> wrote on 03/06/2006 03:12:20 PM:
> When using select into outfile, I can only get the table data, but I
> can't find how to include the column names. I haven't been able to
> include the column names into the actual return of the query, and
> they don't get