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