you have to use 2 select for do this.
The first select generates the headerline and the second the data.

( SELECT 'FieldA','FieldB','FieldC', ... ) UNION ( SELECT `FieldA`,
`FieldB`, `FieldC`, ... INTO OUTFILE 'D:/data.csv'
FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n'  FROM ... ...
GROUP BY `FieldA`, `FieldB`, `FieldC`, ... );

http://lists.mysql.com/mysql/195820

another way is use shell and get a dump. then replace tab with ","

mysql -uuser_name -p  database -e "select * from your_table" > PATH/outfile.txt



~Chamila Gayan




On Mon, Feb 14, 2011 at 11:15 AM, mos <mo...@fastmail.fm> wrote:
> 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
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=cgcham...@gmail.com
>
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=arch...@jab.org

Reply via email to