At 15:55 +0100 5/23/03, R.Dobson wrote:
>I'm using 'select into outfile' in a perl cgi script. The data is
>dumped onto the users local machine in the form of a .csv .xls.
>I'm a little rusty, but I can't remember whether I can't include the
>column names in the dumped results.
>Can you do this with 'select into outfile'?
No. Column names are part of the metadata. When you see those while
running a client such as the mysql program, that's because the client
is displaying them. With SELECT ... INTO OUTFILE, the client never
sees the data because the server dumps the data (and only the data,
not the metadata) into the output file.