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 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] > -- 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]