Okay, so I didn't miss anything... Good to know! Any way I CAN create an output file with those names? Maybe if I make a table first?
One way, if tab-delimited output is satisfactory, is to just run mysql in batch mode.
In interactive mode, you get this kind of output:
mysql> select 1, 2, 3; +---+---+---+ | 1 | 2 | 3 | +---+---+---+ | 1 | 2 | 3 | +---+---+---+ 1 row in set (0.05 sec)
In batch mode, you get this kind of output:
% echo "select 1, 2, 3" | mysql 1 2 3 1 2 3
The first row is the column names. The following rows will be the data. Those are tabs between the columns.
On 4/6/04 21:43, "Paul DuBois" <[EMAIL PROTECTED]> wrote:
At 20:43 -0500 4/6/04, David L. Van Brunt, Ph.D. wrote:I've scoured the online documentation, and I have a good SELECT into OUTFILE
query that gives me what I want... Except that there is no 1st row with
column names.
Hoping I missed something obvious... Any pointers on this one?
You can't do it with SELECT ... INTO OUTFILE.
-- David L. Van Brunt, Ph.D. Outlier Consulting & Development mailto: <[EMAIL PROTECTED]>
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com
MySQL Users Conference: April 14-16, 2004 http://www.mysql.com/uc2004/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]