enabling the output file?

[lubaz]

I wana know of how to use the SELECT...INTO OUTFILE command to create a csv file of query output. Actually, the resulting file doesnot have column headers. Any option that can be turned on/off to enable the output file have column headers? -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[Saggie]

You could write

SELECT 'id'
UNION ALL
SELECT id FROM foo
INTO OUTFILE '/path/to/outfile' -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --