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