Re: SELECT into OUTFILE... Can I add column names?

2004-04-06 Thread David L. Van Brunt, Ph.D.
FABULOUS! It works like a charm, even on a very complex series of commands. Redirected output into a file, and viola! Thanks a bunch! On 4/6/04 22:17, "Paul DuBois" <[EMAIL PROTECTED]> wrote: > At 22:04 -0500 4/6/04, David L. Van Brunt, Ph.D. wrote: >> Okay, so I didn't miss anything... Good to

Re: SELECT into OUTFILE... Can I add column names?

2004-04-06 Thread Paul DuBois
At 22:04 -0500 4/6/04, David L. Van Brunt, Ph.D. wrote: 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, yo

Re: SELECT into OUTFILE... Can I add column names?

2004-04-06 Thread David L. Van Brunt, Ph.D.
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? 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

Re: SELECT into OUTFILE... Can I add column names?

2004-04-06 Thread Paul DuBois
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 w

SELECT into OUTFILE... Can I add column names?

2004-04-06 Thread David L. Van Brunt, Ph.D.
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? -- David L. Van Brunt, Ph.D. Outlier Consulting & Development mailto: