var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Select into Outfile with column names?
does anyone know a good way of selecting data into an output text file
with the column names at the top?
i.e. i'd like the text file to look like
You can't do it using a select to an outfile. From this thread:
I understand you may get what you want using batch mode.
Now I ran it directly from my command prompt and saved the file in the current directory (on WinXP, sure the same works for Linux)
I found I had to name the database i was using or of course got the no db selected error message.
echo SELECT * from animal | mysql -udavemysql -p***** testdb > mysqloutfile.txt
Last edited by guelphdad; 12-06-04 at 19:57.