Column names
"Charles Little" <[email protected]> Sat, 11 Nov 2006 13:44:01 -0500
| Newsgroups | gmane.comp.db.mysql.windows |
|---|---|
| Message-ID | <[email protected]> |
I am new to mysql. I am using the command below: select table1.colum1,table2.column1 from table1,table2 where table1.id=table2.id into outfile 'c:/temp/myfiles/test.txt' lines terminated by '\r\n'; The data goes to the file ok. I would like to know how to get the names of column1 & column2 to be placed at the top of the output. the output file is: I would the following: data data column1 column2 data data data data Thanks, Chuck Little