List:General Discussion« Previous MessageNext Message »
From:Mark Maggelet Date:February 4 2000 3:07am
Subject:Re: into OUTFILE with column headings??
View as plain text  
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>



Thread
into OUTFILE with column headings??Ivan Baxter4 Feb
  • Re: into OUTFILE with column headings??Mark Maggelet4 Feb