Exporting Column Names Questions

[b1cq7]

I'm exporting MySQL data using a sql script containing::

SELECT * FROM (database name)
INTO OUTFILE (filename)
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\r\n';

The file is created successfully but line 1 of the file does not
contain the column names. Is there an option I need to enable in oder
to produce this? Thanks for any assistance offered.

[Bart Van der Donck]

b1cq7 wrote:

I'm exporting MySQL data using a sql script containing::
SELECT * FROM (database name)
INTO OUTFILE (filename)
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\r\n';
The file is created successfully but line 1 of the file does not
contain the column names. Is there an option I need to enable in oder
to produce this? Thanks for any assistance offered.

I 'm afraid this option doesn't exist.

SELECT does include column names, SELECT INTO OUTFILE doesn't. But you
can use SELECT to store query results in a file as well, something
like:

mysql -e "SELECT * FROM mytable" -u[USER] -h[HOST] -p[PASS] [DBNAME] >
/path/to/outputfile

Hope this helps
Bart

[b1cq7]

Bart,
Thanks for the suggestion....seems like a resonable compromise.
ba**@nijlen.com (Bart Van der Donck) wrote in message news:<b5**************************@posting.google. com>...

b1cq7 wrote:

I'm exporting MySQL data using a sql script containing::
SELECT * FROM (database name)
INTO OUTFILE (filename)
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\r\n';
The file is created successfully but line 1 of the file does not
contain the column names. Is there an option I need to enable in oder
to produce this? Thanks for any assistance offered.

I 'm afraid this option doesn't exist.

SELECT does include column names, SELECT INTO OUTFILE doesn't. But you
can use SELECT to store query results in a file as well, something
like:

mysql -e "SELECT * FROM mytable" -u[USER] -h[HOST] -p[PASS] [DBNAME] >
/path/to/outputfile

Hope this helps
Bart