this might not be what you want, but you can do
mysql -se 'select * from table' >outfile
from the shell and that will give you headings.
- Mark
***********************************************
On 2/3/00 at 5:07 PM Ivan Baxter wrote:
>MySQL v.3.21.33b on UNIX.
>I would like to have MySQL send the column names to the files when I do a
>
>SELECT ... into outfile 'x' command.
>
>
>That way the file will have headings for all the columns if I am reading it
>into a spread sheet.
>
>any suggestions??
>
>Thanks
>
>Ivan
>
>--
>---------------------------------------------------------------------
>Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
>posting. To request this thread, e-mail mysql-thread26537@stripped
>
>To unsubscribe, send a message to:
> <mysql-unsubscribe-maggelet=mminternet.com@stripped>
