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', ... )
UNION
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 generates the headerline; the
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 this example helps you to create CSV
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 OUTFILE
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 know how to include the column names, table name,
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
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
, 2006 5:12 PM
To: mysql@lists.mysql.com
Subject: 'Into outfile' doesn't include the column names. How can it be
done?
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
' doesn't include the column names. How can it be
done?
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