List:General Discussion« Previous MessageNext Message »
From:mos Date:February 13 2011 9:50pm
Subject:How to export data with column names?
View as plain text  
I want to use

select * into outfile "myfile.txt" from table1;

and have it export the data as tab delimited but with the column names. I 
need the column names because the import utility will use that to create 
the table in another (non-MySQL) database.

As it stands, I can't get the column names to appear.

Mike

Thread
How to export data with column names?mos13 Feb
  • RE: How to export data with column names?Jerry Schwartz14 Feb