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??
>Please check "" before
>posting. To request this thread, e-mail mysql-thread26537@stripped
>To unsubscribe, send a message to:
>    <>

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